Shalm Posted April 14, 2009 Share Posted April 14, 2009 I seem to be running into a bit a hitch with this and could really use some help. I have been using the various Excel UDF functionalities with great success but once I introduced this specific UDF is when I got my error messages in the console. I am attempting to use this in my script: $MasterARRAY = _ExcelReadSheetToArray($oExcel) but I keep getting this error... C:\Program Files\AutoIt3\Include\Excel.au3 (778) : ==> The requested action with this object has failed.: Local $sLastCell = $oExcel.Application.Selection.SpecialCells($xlCellTypeLastCell).Address(True, True, $xlR1C1) Local $sLastCell = $oExcel.Application.Selection.SpecialCells($xlCellTypeLastCell)^ ERRORI have installed the most recent version of AutoIt after encountering this problem and that didn't seem to help. Are there known bugs with this that have workarounds or limitations to the UDF I don't know about? Any help would be greatly appreciated. Link to comment Share on other sites More sharing options...
Authenticity Posted April 14, 2009 Share Posted April 14, 2009 Did you open any workbook before calling it? Link to comment Share on other sites More sharing options...
PsaltyDS Posted April 14, 2009 Share Posted April 14, 2009 I seem to be running into a bit a hitch with this and could really use some help. I have been using the various Excel UDF functionalities with great success but once I introduced this specific UDF is when I got my error messages in the console. I am attempting to use this in my script: $MasterARRAY = _ExcelReadSheetToArray($oExcel) but I keep getting this error...C:\Program Files\AutoIt3\Include\Excel.au3 (778) : ==> The requested action with this object has failed.: Local $sLastCell = $oExcel.Application.Selection.SpecialCells($xlCellTypeLastCell).Address(True, True, $xlR1C1) Local $sLastCell = $oExcel.Application.Selection.SpecialCells($xlCellTypeLastCell)^ ERROR I have installed the most recent version of AutoIt after encountering this problem and that didn't seem to help. Are there known bugs with this that have workarounds or limitations to the UDF I don't know about? Any help would be greatly appreciated. The range selection may have failed if you are not using an English language version. See Bug Trac #850 for a fix (to be included in future 3.3.1.0 Beta). Valuater's AutoIt 1-2-3, Class... Is now in Session!For those who want somebody to write the script for them: RentACoder"Any technology distinguishable from magic is insufficiently advanced." -- Geek's corollary to Clarke's law Link to comment Share on other sites More sharing options...
Shalm Posted April 15, 2009 Author Share Posted April 15, 2009 I got it to work. It think that it had to do with "protection" settings for the sheet I was using. It started working after I un-protected the sheet even though I don't remember protecting it... I am still not sure exactly what it was, but it seems to be working now. Thanks for your thoughts! 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