| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy Data from One Spreadsheet to Another ?????? | Excel Worksheet Functions | |||
| Copy data to another spreadsheet | New Users to Excel | |||
| HTML controls in spreadsheet | New Users to Excel | |||
| How do I copy spreadsheet data as shown to another spreadsheet? | Excel Discussion (Misc queries) | |||
| How to open another Excel spreadsheet to copy data into current spreadsheet ? | Excel Programming | |||
Linear Mode
