Jump to content

MarkMontemuro

Members
  • Posts

    16
  • Joined

  • Last visited

MarkMontemuro's Achievements

Seeker

Seeker (1/7)

0

Reputation

  1. I'm not sure which forum this question should be addressed to, but are there any AutoIT Conferences where users can get together and discuss various topics such as the various ways users use AutoIT, the future of AutoIT, recommended techniques, etc?
  2. This worked in the previous call 1st Date is:20001030 Last Date is:20141028 using the code below. ConsoleWrite("1st Date is:"&_ExcelReadCell($oExcel, 3,2)&" Last Date is:"&_ExcelReadCell($oExcel, $iRows,2)&@CRLF) Question is how do I then use the Row,Col format in _Excel_RangeRead?
  3. In the previous call I was able to specify a row/column for my ReadCell for example; " _ExcelReadCell($oExcel, $iRows,2)". Can I still use this in the new call _Excel_RangeRead? I can only find examples using this format _Excel_RangeRead($oExcel,Default,"C2"). I do calculations to read cells from certain offsets, $iRows.
  4. Same Input Params as the old & same return values?
  5. I downloaded the latest version of AutoIT in order to get the enhanced performance _ExcelReadSheetToArray function. I'm reading in large excel sheets to an array to compare data & the earlier versions of this function takes a very long time. According to posts, the latest version 3.3.12 has the new Excel UDF that supposedly fixes this problem. With the latest install, I can't find this function in the file. Any suggestions of where I can download a version that has the fix
  6. I have a application that contains many child windows, and they all should support the same right click drop down context menu items like copy, select all, toggle caption bar or status bar , etc. Is there a way within Auto IT or even calling Win32API to discover these items? Thanks
  7. I have a application that contains many child windows, and they all should support the same right click drop down context menu items like copy, select all, toggle caption bar or status bar , etc. Is there a way within Auto IT or even calling Win32API to discover these items? Thanks
  8. I talked to the developer & he will be adding a Stop/Start Feed button which will allow me to take a snapshot without having the cells updated while the ReadSheetToArray function is being executed. Thanks for your input, I think you put me on to solution of the problem.
  9. These sheets are continually being updated by the server. I was hoping that this would just be taking a snapshot of what was currently in the sheet at the time of the funtion call. It is totally possible that the data is changing. I am not switching sheets though. Cells are being updated as stock prices change. The previous reply is very possible and more than likely the issue. Is there a way to freeze the sheet & then read? Like I said, I just wanted to get a snapshot of all the cell values in the sheet. Is there a better solution?
  10. Looks like it is running in 32 bit mode. You can see,it runs, then will just randomly error. >Running:(3.3.8.1):C:Program Files (x86)AutoIt3autoit3.exe "C:Program Files (x86)AutoIt3IBALSSSExacta_Dingo_CME_IB.au3" Current Time Start: 04/01/2013 15:50:25 #1 Symbol: 3:50:27 PM #2 Symbol: 3:50:39 PM #3 Symbol: 3:50:51 PM #4 Symbol: 3:51:03 PM #5 Symbol: 3:51:14 PM #6 Symbol: 3:51:26 PM C:Program Files (x86)AutoIt3IncludeExcel.au3 (823) : ==> The requested action with this object has failed.: $avRET[$r][$c] = $oExcel.Activesheet.Cells($iStartRow + $r - 1, $iStartColumn + $c - 1).Value $avRET[$r][$c] = $oExcel.Activesheet^ ERROR ->15:51:30 AutoIT3.exe ended.rc:1
  11. AutoIt version V3.3.8.1 Windows version Win 7 Windows Bitness (32, 64 bit) 64 Bit Office version 2010 Offcie Bitness (32, 64 bit) 32Bit Tried both versions of AutoIT, both 64 and Native, same results. Also tried, $aArray = _ExcelReadSheetToArray($oExcel). Worse results, did not get all of the cell information
  12. I updated the script to read: $aArray = _ExcelReadSheetToArray($oExcel,4,1) 1st Symbol went through, then the 2nd failed with: C:\Program Files (x86)\AutoIt3\Include\Excel.au3 (787) : ==> The requested action with this object has failed.: Local $sLastCell = $oExcel.Application.Selection.SpecialCells($xlCellTypeLastCell).Address(True, True, $xlR1C1) Local $sLastCell = $oExcel.Application.Selection^ ERROR ->14:37:47 AutoIT3.exe ended.rc:1
  13. I did initially use the _ExcellReadSheetToArray($oExcel,4,1). That is where I started getting this error. I thought that if I restricted the fields I really wanted, that this would reduce the occurances of this error. It did not.
  14. I have an input file which gets stock symbol data from excel. For some reason in the script, The ExcelReadSheetTo Array function radomly throws the error below and terminates the script. If I rerun, it may run fine, If I rerun again, it might error right away. Is there a way to trap this error? or does anyone know why I am receiving this error and have a way around it. Excel Info: ; Title .........: Microsoft Excel COM UDF library for AutoIt v3 ; AutoIt Version : 3.2.3++, Excel.au3 v 1.5 (07/18/2008 @ 8:25am PST) When I call $aArray = _ExcelReadSheetToArray($oExcel,4,1,51,4) ; I frequently receive the following error: C:\Program Files (x86)\AutoIt3\Include\Excel.au3 (823) : ==> The requested action with this object has failed.: $avRET[$r][$c] = $oExcel.Activesheet.Cells($iStartRow + $r - 1, $iStartColumn + $c - 1).Value $avRET[$r][$c] = $oExcel.Activesheet.Cells($iStartRow + $r - 1, $iStartColumn + $c - 1).Value^ ERROR
×
×
  • Create New...