Pasting HTML table into excel - Problem
 

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 ***

Pasting HTML table into excel - Problem
 

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

Pasting HTML table into excel - Problem
 

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 ***