copy html data to spreadsheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

A cell in my spreadsheet contains a hyperlink to an html file. Is there VBA code exist to retrieve specific text - either by matching a text string or by way of a pointer to a specific line of text - from the html file and pasting to a cell in the spreadsheet

Thanks

Kevin
 
Take a look at this thread - posting my Jake Marx

http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&threadm=OEkOBzs2$GA.279@cppssbbsa05

watch word wrap - URL should all be on one line.

--
Regards,
Tom Ogilvy

Kevin said:
A cell in my spreadsheet contains a hyperlink to an html file. Is there
Click to expand...
VBA code exist to retrieve specific text - either by matching a text string
or by way of a pointer to a specific line of text - from the html file and
pasting to a cell in the spreadsheet?
 
Thanks Tom. I'm on my way.

----- Tom Ogilvy wrote: -----

Take a look at this thread - posting my Jake Marx

http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&threadm=OEkOBzs2$GA.279@cppssbbsa05

watch word wrap - URL should all be on one line.

--
Regards,
Tom Ogilvy

Kevin said:
A cell in my spreadsheet contains a hyperlink to an html file. Is there
Click to expand...
VBA code exist to retrieve specific text - either by matching a text string
or by way of a pointer to a specific line of text - from the html file and
pasting to a cell in the spreadsheet?
 
Back
Top