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
|