Hi folks
Ok Im trying to import tables from a supplier of mine that requires a login,
Now doing it manually works fine as you log in as you navigate to the table, however I need a macro that does this automatically, which again once ive logged in once via "get external data" button the macro works fine, however if you close excel, reopen and try to run the macro it doesnt work.
Ive tried running this type of macro 1st, which I got to successfully login via Internet explorer:
But this still doesnt alow me to run the web query macro, it just logs me in on internet explorer.
If I close excell the session times out. I need a way to make the webquery macro log in to the site 1st any ideas?
Thanks in advance
Dave
Bookmarks