Variable

[Conrad]

Would be happy if someone could tell me why this doesn´t work.
I have a name in cell A1 in Excel and want to copy this name,
assaign it to a variabe and print it in cell B1



SetFocus>Microsoft Excel - 2005 304218Bokföringsorder.xls
Press CTRL
Send c
Release CTRL
GetClipboard>Name
Wait>2
Press Tab
Send Character/Text>Name

Conrad

[Bob Hansen]

this doesn´t work.

What happens?
What does not happen?
Does cursor move between cells?
Any messages in status line or any pop up messages?

Script looks good.

Diagnosis questions?
Did you Remove Trailing Spaces?
Did focus really go to that Window name?
Is cursor properly set in A1?
Did you Single Step and look at Watch List to see value of %Name%?
Are either of the spreadsheet cells locked with security?
Is the spreadsheet locked to Read Only?

[fightcancer]

Press CTRL
Send c
Release CTRL

I think you need to have:
Send>c

Though more info about why it's not working wouldn't hurt.

[support]

Here's a much easier way:

Once your script has opened the xls file in Excel do this:

DDERequest>Excel,yourxlfile.xls,R1C1,data,60
DDEPoke>Excel,yourxlfile.xls,R1C2,data

This simply takes the value in row 1, column 1 (cell A1) and then puts it into row 1, column 2 (cell B1).

See:
http://www.mjtnet.com/forum/viewtopic.php?t=1482&