Can I write a Macro to open From Web

[TedX]

Just a quick question, What would be the VBA for writing a simple macro that opens Data/From Web
I'm just after the empty dialogue box to open, that's all. TIA

 

[Dan_W]

Hi. The following should work:

Sub DisplayGetDataFromWeb()
    Application.CommandBars.ExecuteMso "GetPowerQueryDataFromWeb"
End Sub

Is that what you were after?

 

[TedX]

Hi. The following should work:

Sub DisplayGetDataFromWeb()
    Application.CommandBars.ExecuteMso "GetPowerQueryDataFromWeb"
End Sub

Is that what you were after?

Absolutely Dan_W, that is EXACTLY what I wanted and now that I can see the code, I will look into the other CommanBars, thank you very much, you were so helpful.

 

[Dan_W]

You're welcome. A handy way of working out what code to use for certain commands is to go to customize the QAT and hover the mouse cursor over any given menu option amongst the available commands. The code to to use will appear in a tooltip in parentheses. It's difficult to explain, but I'm not in front of my computer at the moment.

 

[Dan_W]

Further to my reply above, I thought it might be easier to understand with a screen capture. As you can see in the image below, the phrase you are looking for is the one at the end in brackets - In this case, the command I'm hovering over will be FormatCellsDialog
So that will just be:

Application.CommandBars.ExecuteMso "FormatCellsDialog"

Hope that's useful.

 

[TedX]

Further to my reply above, I thought it might be easier to understand with a screen capture. As you can see in the image below, the phrase you are looking for is the one at the end in brackets - In this case, the command I'm hovering over will be FormatCellsDialog
So that will just be:

Application.CommandBars.ExecuteMso "FormatCellsDialog"

Hope that's useful.

View attachment 79950

Absolutely useful Dan_W, thank you for going the extra mile

 

[Dan_W]

You're very welcome. Thank you for the kind feedback.