copy html data to spreadsheet
 

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

copy html data to spreadsheet
 

Take a look at this thread - posting my Jake Marx

http://groups.google.com/groups?hl=e...%40cppssbbsa05

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

--
Regards,
Tom Ogilvy

"Kevin" wrote in message
...
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

copy html data to spreadsheet
 

Tom, You might like to take a small trip to tinyurl.com

--
Don Guillett
SalesAid Software

"Tom Ogilvy" wrote in message
...
Take a look at this thread - posting my Jake Marx


http://groups.google.com/groups?hl=e...%40cppssbbsa05

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

--
Regards,
Tom Ogilvy

"Kevin" wrote in message
...
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

copy html data to 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=e...%40cppssbbsa05

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

--
Regards,
Tom Ogilvy

"Kevin" wrote in message
...
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

copy html data to spreadsheet
 

too slow.

Most people can figure out how to construct a URL.

--
Regards,
Tom Ogilvy


"Don Guillett" wrote in message
...
Tom, You might like to take a small trip to tinyurl.com

--
Don Guillett
SalesAid Software

"Tom Ogilvy" wrote in message
...
Take a look at this thread - posting my Jake Marx



http://groups.google.com/groups?hl=e...%40cppssbbsa05

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

--
Regards,
Tom Ogilvy

"Kevin" wrote in message
...
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