Removing tick boxes from Web Data

ICdeadppl · May 20th 2011

Hi

I am a bit of a Warcraft nut and use the data from the webpage to determine the best gear to obtain.
I have a macro for extracting data from this webpage when I have copy/pasted it to excel, however I can't seem to work out how to delete the tick boxes once copied to excel.

http://www.wowhead.com/items?f…:22:18:16:16:11;gb=1#head

I copy the data from the title "Name" downwards if you want to reproduce the problem.

ICdeadppl · May 27th 2011

Re: Removing tick boxes from Web Data

Bump

junho lee · May 27th 2011

Re: Removing tick boxes from Web Data

Hi ICdeadppl,
For me this works.
http://www.pcreview.co.uk/foru…-check-boxes-t977997.html

Code

Sub tester2()
Dim obj As OLEObject
For Each obj In ActiveSheet.OLEObjects
If LCase(TypeName(obj.Object)) = "htmlcheckbox" Then
obj.Delete
End If
Next
End Sub

Regards, junho

Removing tick boxes from Web Data

Participate now!

Share