Get External Data From Web

Helpme21

New Member
Joined
Jan 26, 2011
Messages
19
Hello -

I am creating a tool that many people will be using. I need a way to do the following from vba:

1. Click on the "From Web" button under Get External Data section in Data and show the web query pop-up
2. Input the url into the field and press enter

At this point, it will be the user's responsibility to log in w/ their username and password. I have tried to record a macro w/ no success. I just need to get the query open for the user without them having to do anything.

Thanks in advance!
 

Some videos you may like

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes

GRTorres

Active Member
Joined
Nov 19, 2012
Messages
344
Hello Helpme21,

I do not believe you are going to be able to do this. The Add Query Application with VBA should only allow you to do the function from start to finish. Thus, it wont recognize what you are recording (macro) until the process is complete. Someone might have a bit more experience with it, but I dont think you will be able to.
 

Helpme21

New Member
Joined
Jan 26, 2011
Messages
19
So I guess this is impossible? Is there any other way to get excel to log into a website so it can get the source code of the webpage?
 

Watch MrExcel Video

Forum statistics

Threads
1,122,437
Messages
5,596,112
Members
414,042
Latest member
Swiftkoala

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top