Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Mar 2004
    Location
    North Carolina, USA
    Posts
    268
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Import/Copy From Internet Explorer (2007)

    I am attempting to get some data from Fidelity.com into Excel. I have attempted to right click and export into to Excel w/no luck. I can copy and paste the data but it gets out of order - what should for example stay in column A moves to B, etc.

    Any ideas. Note: This is coming from a secure site - if this makes a difference.

  2. #2
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Import/Copy From Internet Explorer (2007)

    Have you tried to "import" the data from the web page into Excel?

    In Excel, select the DATA tab and click on the "From Web" button in the Get External Data group. This will open the New Web Query dialog where you can browse to the specified web site and import data.

    The data is imported as text only unless you click on the Options button on the dialog and choose to import with Full HTML formatting.
    Regards,
    Rudi

  3. #3
    3 Star Lounger
    Join Date
    Mar 2004
    Location
    North Carolina, USA
    Posts
    268
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Import/Copy From Internet Explorer (2007)

    Don't see this as option. Tried all I see and no go... Tried saving as various file types... No luck

  4. #4
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Import/Copy From Internet Explorer (2007)

    >> Don't see this as option?? Why not??

    Don't you see the From Web button or is it not importing the data you want? What is it exactly that you need imported into Excel?
    Attached Images Attached Images
    Regards,
    Rudi

Posting Permissions

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