Jump to content
Sign in to follow this  
Lamont

AutoIt limitation (???) with cut/paste

Recommended Posts

Lamont

Hello all....need some help/advice please....

Using an AutoIt While loop to cut a cell in an Excel 2007 window then paste into another non-Excel window.....works fine for around 400 cut/paste operations, then stops working....snipet of code below:

;--- Excel window ---

Send("^c") ;copy cell to clipboard

$var = ClipGet()

.

.

.

;--- non_Excel window ---

$var_verify = ClipGet()

If $var_verify <> $var Then

MsgBox(16, "Abort run", "Excel var does not match non-Excel var")

EndIf

Behavior suggests some type of timeout or limit is being reached. I've tried programming into the While loop commands to clear the Excel clipboard, but does have any effect on the outcome.

Any suggestions what might be occurring ???

Thanks,

Lamont

Share this post


Link to post
Share on other sites
jdelaney

why use the clipboard at all, read into a variable.

_ExcelReadCell

Edited by jdelaney

IEbyXPATH-Grab IE DOM objects by XPATH IEscriptRecord-Makings of an IE script recorder ExcelFromXML-Create Excel docs without excel installed GetAllWindowControls-Output all control data on a given window.

Share this post


Link to post
Share on other sites
Lamont

While positioned at the Excel spreadsheet cell, what would command to use? For instance, if variable is $var, how would I code......$var = ????????

Share this post


Link to post
Share on other sites
jdelaney

Try to string together something simple, if you have troubles, post what you have, and someone will help.


IEbyXPATH-Grab IE DOM objects by XPATH IEscriptRecord-Makings of an IE script recorder ExcelFromXML-Create Excel docs without excel installed GetAllWindowControls-Output all control data on a given window.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×