Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Convert excel table to HTML | Excel Discussion (Misc queries) | |||
Allow Excel to retain HTML hypertex done from another editor. | Excel Discussion (Misc queries) | |||
Convert HTML into an Excel | Excel Worksheet Functions | |||
Copying an Excel spreadsheet to a Word document | Excel Discussion (Misc queries) |