Pasting a variable

[Zombie1982]

Good morning,

I have a bit of an issue I can't nut out. Is there a way to paste a variable instead of typing it?

Much like "Send(^v $CName1)" or something like it, or am I dreaming?

Thanks in advance.

[maqleod]

Good morning,

I have a bit of an issue I can't nut out. Is there a way to paste a variable instead of typing it?

Much like "Send(^v $CName1)" or something like it, or am I dreaming?

Thanks in advance.

what exactly are you trying to do?

Edit: Maybe ClipGet()?

Edited April 1, 2009 by maqleod

[Zombie1982]

what exactly are you trying to do?

Edit: Maybe ClipGet()?

Basically the user enters a name at the beginning of the script and the script then types that into a field in Excel. Though typing takes around 1 minute, actually pasting the name takes only seconds.

In fact, ClipPut and ClipGet might work nicely... I'll test it now and let you know how it goes.

EDIT: That worked a treat! You are a prince among men, Magleod!

Edited April 1, 2009 by Zombie1982

[maqleod]

Basically the user enters a name at the beginning of the script and the script then types that into a field in Excel. Though typing takes around 1 minute, actually pasting the name takes only seconds.

In fact, ClipPut and ClipGet might work nicely... I'll test it now and let you know how it goes.

if you are using Excel, you should have a look at the Excel UDF in the help file, that will be a much more efficient means of writing data from an input into specified cells in a spreadsheet

[bo8ster]

Just looking at that too. There a number of Excel UDFs round the place, http://www.autoitscript.com/forum/index.php?showtopic=34302 is an active one.

[maqleod]

Just looking at that too. There a number of Excel UDFs round the place, http://www.autoitscript.com/forum/index.php?showtopic=34302 is an active one.

That is a good one too, I have used that one in the past