Excel getting external data.
 

Is it possible in excel to get external data directly from a website that has a requirement for a username and password? I want to (in VBA) access weather from a met website inserting username and password in code to bypass the login page. This excel program is to live in a memory stick as I want to use it in several different computers. These computers will not have RoboForm or other such software.
Ta in advance.

Can it be done?
 

:confused:
Is my ? too complex. I get no answers. :ugh:

A webquery will prompt you for username and password when it executes. The webquery object doesn't expose the necessary properties to allow you to programmatically set them. You could either try sending keystrokes to the dialog box, use something more suited to the task than Excel or use a weather source that doesn't require authentication.