View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Tim Williams Tim Williams is offline
external usenet poster
 
Posts: 1,588
Default 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 ***