Hi can anyone help or point me in the right direction.
I need to access website information using vba from a button on a form.
eg
www.google.co.uk/news, I then want to extract some of the relevant information from that page ( This will be from a private website using a sign on eventually).
I have read most of the posts on this subject and have tried to implement the suggestions without any success. Can anyone help ? , i currently make up the link into a text box and try to access it using the following code.
dim WSCtrl as commandbutton
dim WebAddress as string
with WSCtrl
.hyperlinkaddress=webaddress
.hyperlink.follow
end with
Regards
Ian Clegg
I need to access website information using vba from a button on a form.
eg
www.google.co.uk/news, I then want to extract some of the relevant information from that page ( This will be from a private website using a sign on eventually).
I have read most of the posts on this subject and have tried to implement the suggestions without any success. Can anyone help ? , i currently make up the link into a text box and try to access it using the following code.
dim WSCtrl as commandbutton
dim WebAddress as string
with WSCtrl
.hyperlinkaddress=webaddress
.hyperlink.follow
end with
Regards
Ian Clegg