Excel getting external data.
Thread Starter
Join Date: Jan 2000
Location: Dublin, Ireland
Posts: 19
Likes: 0
Received 0 Likes
on
0 Posts
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.
Ta in advance.
Join Date: Sep 2002
Location: London, UK
Posts: 778
Likes: 0
Received 0 Likes
on
0 Posts
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.