#1
|
|||
|
|||
Macro - Get External Data From Web
Hello All,
Can you please let me know if there is a command in macro that will open the get external data window? To describe my problem, I have created the macro that import tables with stats from the website (monthly statistics where user select which months to import). The problem is the website requires a login. It works when i manually click on the get external data, log in, close web query window and then run the macro. What i need is to implement the login into another macro, best would be a command that will open the Get external data and let user to manually log in. Using the internet explorer application does not do the job as excel do not "remember" or recognize being logged in and therefore the macro cannot access the tables. Many thanks, Kind regards, Wries |
#2
|
|||
|
|||
Hello, let me answer my question in case someone else is looking for the same macro.
I havent been able to find a direct command, if anyone can solve it without using sendkeys please share your solution. For the time being the following seems to work: Sub GetExternalDataFromWeb() SendKeys "%" SendKeys "d" SendKeys "d" SendKeys "w" End Sub Kind regards, Wries |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
drop down list from external data source Excel 2007? | Intruder | Excel | 1 | 08-03-2012 05:41 AM |
vba change external data source | excelledsoftware | Excel Programming | 1 | 07-17-2012 04:22 AM |
Refresh of data from external source | Jirik61 | Excel Programming | 3 | 07-13-2012 01:40 PM |
Consolidating data using Macro | mrjamez | Excel Programming | 2 | 05-22-2012 06:50 AM |
Help w/ external data | bellest | Excel | 0 | 11-11-2005 12:51 PM |