Hello all, i have a HTML page (Print Preview) out of which i want to
copy a table, can this be done automatically ?
If not, i can do it manually but i am left with a lot of hyperlinks that
i need to get ride of and i loose all the dates that are on the preview,
even if i format the column for "date".

Any suggestions or help would be much appreciated...

Best regards,

Les Stout

*** Sent via Developersdex http://www.developersdex.com ***

Hi Lee

Could you use a Web Query to do it?? Or have you tried this
already?? If not it can be found under the Data Menu / Import
External Data / New Web Query. From here navigate to your page and
click the arrow beside the table you want and then Click Import.

Steve

Print preview from where, the browser?
If you have a copy in IE you could use the HTML Document Object Model to
copy the table contents to Excel (by iterating through the rows & cells and
copying their contents)

Tim


"Les Stout" wrote in message
...
Hello all, i have a HTML page (Print Preview) out of which i want to
copy a table, can this be done automatically ?
If not, i can do it manually but i am left with a lot of hyperlinks that
i need to get ride of and i loose all the dates that are on the preview,
even if i format the column for "date".

Any suggestions or help would be much appreciated...

Best regards,

Les Stout

*** Sent via Developersdex http://www.developersdex.com ***