Lamont Posted November 30, 2012 Share Posted November 30, 2012 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 Link to comment Share on other sites More sharing options...
jdelaney Posted November 30, 2012 Share Posted November 30, 2012 (edited) why use the clipboard at all, read into a variable. _ExcelReadCell Edited November 30, 2012 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. Link to comment Share on other sites More sharing options...
Lamont Posted November 30, 2012 Author Share Posted November 30, 2012 While positioned at the Excel spreadsheet cell, what would command to use? For instance, if variable is $var, how would I code......$var = ???????? Link to comment Share on other sites More sharing options...
jdelaney Posted November 30, 2012 Share Posted November 30, 2012 Use the helpfile. Look up all the _excel functions. 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. Link to comment Share on other sites More sharing options...
Lamont Posted November 30, 2012 Author Share Posted November 30, 2012 Thanks.....I'll try it. Link to comment Share on other sites More sharing options...
jdelaney Posted November 30, 2012 Share Posted November 30, 2012 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. Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now