+ Reply to Thread
Results 1 to 3 of 3

Copying HTML into Excel Losing Hyperlinks

  1. #1
    Davud Levitt
    Guest

    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

  2. #2
    David McRitchie
    Guest

    Re: Copying HTML into Excel Losing Hyperlinks

    Hi David,
    You have like 7 or more links in each cell in the last column, Excel
    can only include one link per cell. Often I think you would
    get the first link and underscored blue for the entire cell
    regardless of content. In this case I get the wording
    but no link. Isn't that what you really get. That's the
    way Excel works -- I'm sure what you are trying to do
    would work in MS Word, but they are not the same.

    Actually I just did a normal paste, but the Edit, PasteSpecial HTML
    worked the same way.
    ---
    HTH,
    David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
    My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
    Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

    "Davud Levitt" <Davud Levitt@discussions.microsoft.com> wrote in message news:8623B889-5C3B-46D5-9492-611B4E59BF37@microsoft.com...
    > 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. #3
    exceluserforeman
    Guest

    RE: 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 to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1