Results 1 to 8 of 8
  1. #1
    3 Star Lounger baumgrenze's Avatar
    Join Date
    Feb 2001
    Location
    California, USA
    Posts
    262
    Thanks
    6
    Thanked 0 Times in 0 Posts

    Pasting from IE (Excel SR 9.0.3821 SR-1)

    I have created an Excel spreadsheet using material copied and pasted from a web site viewed in IE 5.50.4522.18001C. I find that I can undo some of the formatting supplied in the process, but I am left with a series of annoying blue boxes in the upper left corner of many of the rows. These print out in black and obscure some of the text. I can't find anything in the Help file that is indexed for this phenomenon. Right clicking does not seem to offer any options to remove them. What are they? Can I do a global delete? (I know through experience that a similar copy and paste into Word generates a multi-leveled table that can be tricky to navigate and simplify.

    Thanks,

    John
    Baumgrenze
    Hier sind wir tief eingewurzelt.

  2. #2
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Pasting from IE (Excel SR 9.0.3821 SR-1)

    Have you tried copying (possibly using GoTo, Special, Constants, Text) and repasting the text over itself using Paste Special, Text? If it doesn't help could you post the WB?
    -John ... I float in liquid gardens
    UTC -7ąDS

  3. #3
    3 Star Lounger baumgrenze's Avatar
    Join Date
    Feb 2001
    Location
    California, USA
    Posts
    262
    Thanks
    6
    Thanked 0 Times in 0 Posts

    Re: Pasting from IE (Excel SR 9.0.3821 SR-1)

    John,

    Thanks for the prompt reply. I think I know what I am pasting. In View>Source in IE I find the following HTML coding:

    [img]/images/bbul5.gif[/img]

    just before the text that ends up in a cell with the 'blue box.'

    So the offending bit is an image of a shadowed bullet point.

    I think I can remove them one at a time by changing the size to "0" but, I guess that means there is no global removal technique unless a macro can be written to find images one at a time and resize them to "0."

    I have the same beef with regard to hypertext linked items, both in Excel and Word.

    Thanks again,

    John
    Baumgrenze
    Hier sind wir tief eingewurzelt.

  4. #4
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Pasting from IE (Excel SR 9.0.3821 SR-1)

    My suggestion to paste the text over itself using Paste Special, Text should get rid of it. If not, could you post a sample WB as an attachment?
    -John ... I float in liquid gardens
    UTC -7ąDS

  5. #5
    3 Star Lounger baumgrenze's Avatar
    Join Date
    Feb 2001
    Location
    California, USA
    Posts
    262
    Thanks
    6
    Thanked 0 Times in 0 Posts

    Re: Pasting from IE (Excel SR 9.0.3821 SR-1)

    I have attached one page of a spreadsheet of property tax information from the Alameda County Assessor's web site. I obtained the information at:

    http://www.co.alameda.ca.us/assessor/property_info/

    I entered and submitted two parcel numbers, in succession, 40A-3427-35, and 40A-3427-36-1.

    I copied and pasted to Excel the "Property Assessment Information" starting on the Address line. I also linked to "Property Tax Information" and copied and pasted the data portion of that table.

    When I tried "Paste Special>Text" everything ends up in the first column

    I did manage to get a clean spreadsheet via a round about method. I pasted the information from IE to Word, converted the resulting tables to text using the tab option, saved the document as a text file, and then opened it in Excel. That also got rid of the pesky hypertext links as well. Perhaps it is the most efficient way.

    Thanks again,

    John
    Attached Files Attached Files
    Baumgrenze
    Hier sind wir tief eingewurzelt.

  6. #6
    3 Star Lounger
    Join Date
    May 2002
    Location
    Mpls, Minnesota, USA
    Posts
    271
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pasting from IE (Excel SR 9.0.3821 SR-1)

    baumgrenze,
    I use Excel 97 SR2, but wanted to try it. I can get rid of the blue squares (pics) easy.
    I used the GoTo Special and selected Objects. All the squares are then highlighted and pressing the delete key gets rid of them all. It might work in you version as well.
    Chuck
    Chuck Reimer
    I'm from the Government and I'm here to help...

  7. #7
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Pasting from IE (Excel SR 9.0.3821 SR-1)

    Chuck has your answer. You could also have used the following macro:

    Sub DelShapes()
    Dim oShape As Object
    For Each oShape In ActiveSheet.Shapes
    oShape.Delete
    Next oShape
    End Sub

    or better yet

    Sub DelDrawingObjects()
    ActiveSheet.DrawingObjects.Delete
    End Sub

    It was helpful of you to post the WB, as we could then determine that these were shapes, not HTML codes as I mistakenly thought, and this was also the reason my earlier suggestion was never going to work.

    If you need to copy from websites into WB's in the future, it would still be best to Paste Special, Text.
    -John ... I float in liquid gardens
    UTC -7ąDS

  8. #8
    3 Star Lounger baumgrenze's Avatar
    Join Date
    Feb 2001
    Location
    California, USA
    Posts
    262
    Thanks
    6
    Thanked 0 Times in 0 Posts

    Re: Pasting from IE (Excel SR 9.0.3821 SR-1)

    Thank you Chuck and John. I'm sure that the concept of GoTo Special>Objects is in the Help somewhere. The secret is knowing the exact words to use to search the index. Usually that means you already also know the solution!

    John
    Baumgrenze
    Hier sind wir tief eingewurzelt.

Posting Permissions

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