I'm returning external data to a worksheet using MS Query over an external database. The database wants a password on the initial refresh after that I can get it to refresh requalrly throughout the day.
How do I get VBA to populate the password request.
I've tried sendkeys without success. Have managed to get the password on my worksheet though. How do I select the password dialog box to sendkeys into?
ziggy
How do I get VBA to populate the password request.
I've tried sendkeys without success. Have managed to get the password on my worksheet though. How do I select the password dialog box to sendkeys into?
ziggy
