Open source code for a hyperlink

John Bennito · May 3rd, 2002, 10:28 AM

Currently in cell "a1" I have a hyperlink to an html document.

I would like to open or obtain the source code for that html document.

Currently I am clicking on the hyperlink and then when the page opens in Internet Explorer - I click on source and then save the html code in the text format.
I would like to automate this process by doing this in vba code.

Any suggestions

Many Thanks

John

waderw · May 3rd, 2002, 10:56 AM

Hmmmmm..I'm not sure about that one. Try recording this. I doubt it will work once you leave Excel but worth a try.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 3rd, 2002, 10:28 AM	#1
John Bennito New Member Join Date: Feb 2002 Posts: 11	Currently in cell "a1" I have a hyperlink to an html document. I would like to open or obtain the source code for that html document. Currently I am clicking on the hyperlink and then when the page opens in Internet Explorer - I click on source and then save the html code in the text format. I would like to automate this process by doing this in vba code. Any suggestions Many Thanks John

May 3rd, 2002, 10:56 AM	#2
waderw Board Regular Join Date: Apr 2002 Posts: 85	Hmmmmm..I'm not sure about that one. Try recording this. I doubt it will work once you leave Excel but worth a try.