HTML link and extracting Javascript content?

Andrew Poulsom

MrExcel MVP

Joined

Jul 21, 2002

Messages

73,092

• Mar 16, 2010

• #2

In VBA:

ActiveSheet.PasteSpecial Format:="Unicode Text", Link:=False, DisplayAsIcon:=False

You need to select the target cell first. Note that the PasteSpecial method of the Worksheet object is different from the PasteSpecial method of the Range object.

 

Upvote 0

L

London_Calling

Active Member

Joined

Feb 27, 2007

Messages

256

• Mar 16, 2010

• #3

Hi Andrew,

So I can get to the Unicode Text method via the Worksheet object - thank you for that!

I can't quite get my head around selecting the "target cell" (is that the copy cell or the paste cell?) and then ActiveSheet.PasteSpecial - a cell and then a sheet . . . I'm obviously misunderstanding your advice.

Thanks for the help.

 

Upvote 0

Andrew Poulsom

MrExcel MVP

Joined

Jul 21, 2002

Messages

73,092

• Mar 16, 2010

• #4

The Worksheet's PasteSpecial method pastes into the active cell. So you need to select it first (unless you don't care where the data is pasted).

 

Upvote 0

L

London_Calling

Active Member

Joined

Feb 27, 2007

Messages

256

• Mar 16, 2010

• #5

Ok, officially I'm having a thick morning . . . and I'm going nuts; could you please point out where I'm going wrong!!

Code:

Range("A6").Select
Selection.Copy
ActiveCell.Offset(0, 5).Select
ActiveSheet.PasteSpecial Format:="Unicode Text", Link:=False, DisplayAsIcon:=False

 

Upvote 0

Andrew Poulsom

MrExcel MVP

Joined

Jul 21, 2002

Messages

73,092

• Mar 16, 2010

• #6

You use the Worksheet's PasteSpecial method when you are pasting from an external application (eg Word, which you mentioned in your first post). You use the Range's PasteSpecial method when pasting within Excel.

 

Upvote 0

L

London_Calling

Active Member

Joined

Feb 27, 2007

Messages

256

• Mar 16, 2010

• #7

Sure, I did it in Word to see if it was possible. I guess you're saying it isn't possible to do it within Excel (i.e. Range > PasteSpecial > Unicode Text).

Thanks very much for you time, Andrew - have a good one!

 

Upvote 0

L

London_Calling

Active Member

Joined

Feb 27, 2007

Messages

256

• Mar 16, 2010

• #8

Hi, I'm just re-stating this in case any of the evening crew have a suggestion. I import web page HTML links into Excel and I'd like to extract the javascript contained within the link, like this:

HTML link contains:

Code:

 javascript:showProfile('person','59472')

I'd like to paste that javascript in an offset cell.

It doesn't seem possible to extract the code within Excel as (so far) I've only been able to do it from Word using PasteSpecial > Unicode Text, and you can't do that within Excel.


Just looking for any bright ideas, really. Tricky one, I suspect!

Cheers.

 

Upvote 0