+ Reply to Thread
Results 1 to 2 of 2

copy from webpage pulls in javascript icon, how to remove?

  1. #1
    Registered User
    Join Date
    10-24-2007
    Posts
    1

    copy from webpage pulls in javascript icon, how to remove?

    Hi. I am creating a mailing list, and I need to copy some information from a table on a website. The site blocks exporting, but I can copy and paste the info. When I paste it, on several of the fields is a yellow box with a slanted "J" on it. If I hover over the yellow box, the text box contains what looks like javascript. I can manually delete the yellow box, but having over 5600 lines and 150,000 yellow boxes, it hardly seems practical. Is there some one to make the javascript boxes go away all at once? If not, will the javascript boxes prevent importing the excel spreadsheet into outlook?
    Last edited by VBA Noob; 10-24-2007 at 10:38 AM.

  2. #2
    Forum Moderator Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2007, 2013
    Posts
    6,407
    Hello scrubbie1,

    The following code will delete all Objects on your worksheet (from http://www.rondebruin.nl/controlsobjectsworksheet.htm):
    copy to clipboard
    Please Login or Register  to view this content.
    To use this code:
    1. Right-click on your sheet tab
    2. Click 'View Code'
    3. Copy the code above and paste it into the empty VBA window
    4. Press ALT+Q to close the VBA Editor and return to Excel
    5. Press ALT+F8 to open the Macros window
    6. Select 'yoursheetname.Shapes1' and click Run

+ 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