macro that uses "get external data" website passwo

hackep1

New Member
Joined
Mar 1, 2006
Messages
5
I have a excel sheet that contains macro's to fetch data from a web page. This works great except for one thing. I need to get this to run automaticaly, only problem the website uses username an passwords.

When you refresh the data a windows login box appears, It already contains the login details as I have saved them but needs you to press enter.

Does anyone know of a way to automate this?
 

Some videos you may like

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

Watch MrExcel Video

Forum statistics

Threads
1,114,384
Messages
5,547,621
Members
410,804
Latest member
bluepinky
Top