Copy/Paste w/o all the styles from web & links...

  • Thread starter Thread starter orbii
  • Start date Start date
O

orbii

hi, i do a lot of work w/ the web on data, and everytime i copy from web and
paste into excel, it transfer all the styles over. is there a way to switch
it off? that includes the links too, can that be turned off too?

i'm having it up to my neck trying to figure out how i can do this in a lot
more simpler way. i dont' want to have to every time...

copy from web >
paste excel sheet1 >
recopy entire sheet1 >
paste notepad >
recopy entire notepad >
paste excel sheet2 >
formatting... etc etc

just a note on the side, copying from the web to notepad i loose my tab
delaminated value, so can you imagine the amount of time this takes?
thankyou so much for he/she who can help me with this dilemma :(

orb
 
Hi
have you tried 'Paste Special' ('Edit - Paste Special'):
- either directly after copying from your web page
- or after you have copied the data select the data, copy it and insert
it again on a blank sheet as Values. You may record a macro while doing
this
 
I don't do enough copying and pasting from the web to excel to know for sure.

But newer versions of excel can sometimes open the web page directly (and the
newer the version, the better the conversion).

Maybe you could try:
File|Open
and specify your web site
like: http://my.yahoo.com

Then after you retrieve it, could you clean it up within excel.

This kind of code will remove the hyperlinks from a worksheet:

ActiveSheet.Cells.Hyperlinks.Delete

Then you could make use of excel's normal style:

ActiveSheet.Cells.Style = "Normal"

And keep adjusting the stuff you want--font color, size, etc.

And you could delete all the shapes, too. Then copy the good stuff and paste
into its real home:

Option Explicit
Sub testme()
Dim iCtr As Long

With ActiveSheet
.Cells.Hyperlinks.Delete
.Cells.Style = "Normal"
For iCtr = .Shapes.Count To 1 Step -1
.Shapes(iCtr).Delete
Next iCtr
End With

End Sub

====
You may want to look at Data|Get External Data (Or Data|Import external data)

Maybe retrieving the data that way will make things easier.
 
Back
Top