Sign in to follow this  
Followers 0
Lamont

AutoIt limitation (???) with cut/paste

6 posts in this topic

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



#2 ·  Posted (edited)

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

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

Thanks.....I'll try it.

Share this post


Link to post
Share on other sites

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  
Followers 0