Forum Discussion
Adding a Button to start command
I have added a button to a spreadsheet using the developer tab. I want it to start the command Data>Get External Data>From Text. Im using a button instead of the Ribbon to make it more user frien...
This is the line of code that starts the Get & Transform text import wizard:
Application.CommandBars.ExecuteMso "GetPowerQueryGetTransformDataFromText"
but I doubt if that is what you are looking for. More likely you need this one:
Application.CommandBars.ExecuteMso "GetExternalDataFromText"
Application.CommandBars.ExecuteMso "GetPowerQueryGetTransformDataFromText"
but I doubt if that is what you are looking for. More likely you need this one:
Application.CommandBars.ExecuteMso "GetExternalDataFromText"