Apple

On Feb 4, 2011, at 3:18 PM, Gaurav Walia wrote:

I'm thinking to script excel (have all2004 – 2011)

tell application "Microsoft Excel"

activate

make new hyperlink of active cell at active sheet with properties {address:"Sheet2!A1"}

end tell

This executes. The problem is that when you click on the hyperlink there is an error. Looking at the link. It's missing the "#" in the field

Objective is to get the field (command+K) to display #Sheet2!A1". The code above doesn't work.

Changing this address:"Sheet2!A1" to address:"#Sheet2!A1" gets "#Sheet2!A1#Sheet2!A1" in the field.

So how do I get the link to field to display #Sheet2!A1?

tell application "Microsoft Excel"

activate

make new hyperlink of active cell at active sheet with properties {sub address:"Sheet2!A1", address:""}

end tell

References:
	>excel - hyperlinks errors (From: "Walia, Gaurav (333G)" <email@hidden>)