Copying HTML into Excel Losing Hyperlinks
Hi All,
If I copy a html table from a website such as http://screen.yahoo.com/b?mc=/100000...ocks&vw=1&b=21 and then past the contents into Excel using the Paste Special HTML pasting command the last column in my spreadsheet no longer contains the hyperlinks that were contained within the copied website. I should note that I do not have this problem when pasting the same website content into Microsoft Word. Does anyone know this is happening in Excel and is there an easy work around for this problem. Thanks, David Levitt |
Copying HTML into Excel Losing Hyperlinks
Hi,
Use a web query with full HTML Formatting. DATA Import External query or try my WebTableImport utility at http://www.geocities.com/excelmarksway - Mark "Davud Levitt" wrote: Hi All, If I copy a html table from a website such as http://screen.yahoo.com/b?mc=/100000...ocks&vw=1&b=21 and then past the contents into Excel using the Paste Special HTML pasting command the last column in my spreadsheet no longer contains the hyperlinks that were contained within the copied website. I should note that I do not have this problem when pasting the same website content into Microsoft Word. Does anyone know this is happening in Excel and is there an easy work around for this problem. Thanks, David Levitt |
All times are GMT +1. The time now is 07:32 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com