Sbirro Cornuto
Board Regular
- Joined
- Mar 18, 2002
- Messages
- 93
I know how to open the web site. I do it with code like this:
*********************************************
Application.DisplayAlerts = False
ActiveWorkbook.FollowHyperlink Address:= _
"http://www.bof.fi/ohi/fin/0_new/0.1_valuuttak/fix-fin-bw.htm", NewWindow:= _
True, AddHistory:=False
Application.WindowState = xlMaximized
*********************************************
How could I read the data from that web site programmatically?
Now I have the user searching the correct line manually and copying and pasting it to the use of my program.
I´m assuming this could all be done automaticly since the data is in the kind of a form that it is. (Check it out)
http://www.bof.fi/ohi/fin/0_new/0.1_valuuttak/fix-fin-bw.htm
I just don´t know where to start, do YOU?
Thx in advanz
Sbirro
*********************************************
Application.DisplayAlerts = False
ActiveWorkbook.FollowHyperlink Address:= _
"http://www.bof.fi/ohi/fin/0_new/0.1_valuuttak/fix-fin-bw.htm", NewWindow:= _
True, AddHistory:=False
Application.WindowState = xlMaximized
*********************************************
How could I read the data from that web site programmatically?
Now I have the user searching the correct line manually and copying and pasting it to the use of my program.
I´m assuming this could all be done automaticly since the data is in the kind of a form that it is. (Check it out)
http://www.bof.fi/ohi/fin/0_new/0.1_valuuttak/fix-fin-bw.htm
I just don´t know where to start, do YOU?
Thx in advanz
Sbirro