PDA

View Full Version : import data from password protected website into Excel worksheet



megtoma
03-13-2011, 02:33 PM
Hello,
I would like to import data from a password protected website and be able to refresh it. Could you please provide me with VBA code?

Aussiebear
03-13-2011, 02:54 PM
Do you know the password to the website?

megtoma
03-13-2011, 03:52 PM
yes. The website is: infinancials.com/Eurofin/fundamentals.jsp?mode=0&company_id=21298EX and the password: c6213b9
I know how to import the data but I would like to be able to refresh the data. It is not possible since the website is password protected. Do you have any solution for that?

Jan Karel Pieterse
03-14-2011, 02:47 AM
Check out:

http://www.dailydoseofexcel.com/archives/2011/03/08/get-data-from-website-that-requires-a-login/

megtoma
03-14-2011, 05:16 AM
THANK YOU!!!