PossumJohn

Thanks for your help! I'll print and read the upates and online docs now that I have a few spare minutes. I don't think I'll have a problem with UniCode as all of the PCs are Win XP Pro and servers are Win 2000 or Win 2K3. Have a great week, PJ

Thanks to both of you!! I'm a proponent of "RTFM" , but I got caught off-guard when our Enterpeise Symantec deleted all of my compiled AutoIT scripts and the AutoWrapper executable yesterday morning. I really needed to complete a script I started developing on Wednesday so I went to the Web site and discovered that there were new releases of of AutoIT and SciTE. Symantec seems to like the new stuff -- for now. As far as using the directives, I just need to figure out what the defaults are and then set something up to automatically include the rest of my favorite settings. HOMEWORK!! Have a great weekend, PJ

I liked the GUI in AutoIT3Wrapper because it allowed me to visually select an icon to use for the executable instead of going to Windows Explorer to see the icons and then copying & pasting the ICO file name onto the directive line. Is this what the "#AutoIt3Wrapper_Res_Icon_Add" directive does? I know -- I should read the Help file. I will do so after work tonight -- when I have more time. I assume that there is a list of the AutoIT3Wrapper directives there also. In any case -- thanks to all for such a great tool!! Have a great day, PJ

Thanks! I didn't mean to be a pain. I just figured that if you were busy at the moment someone else might have the answer. I've downloaded the new UDF and will give it a try in a little bit. Thanks again & have a great week, PJ

Hello to All!! I'm trying to automate the writing of Oracle SQL-Plus Insert statements and I'm having a problem with the "_ExcelSheetUsedRangeGet" function in _ExcelCom. I reviewed the function comments and thought I was using it correctly, but it always seems to return a zero for the number of rows. The code that I'm using is below. As I said, I keep getting "0" returned for the last row number and I'm positive that there are 15 rows used in the sheet. I apperciate any help I can get with this. Thanks & have a great day, PJ Local $oExcel = _ExcelBookOpen($Get_In_Fyle, 1) Dim $Num_Rows[4] $CurrRow = 1 $Record_Cnt = 0 $Num_Rows = _ExcelSheetUsedRangeGet($oExcel, 1) SplashTextOn("DeBug","Last Cell Used " & $Num_Rows[0] & @CRLF & "Last Cell Used " & $Num_Rows[1] & @CRLF & "Last Col Used " & $Num_Rows[2] & @CRLF & "Number of rows = " & $Num_Rows[3], 500, 200, -1, 50, 4, "", 12) Sleep(300) MsgBox(4096,"DeBug", "Number of rows = " & $Num_Rows[3]) ; MsgBox(4096,"DeBug", "Control Number = " & $Ctrl_No) For $Cell = 1 to $Num_Rows[3] $Ctrl_No = _ExcelReadCell($oExcel, $Cell, 1) MsgBox(4096,"DeBug", "Control # = " & $Ctrl_No & @CRLF & "Cell # = " & $Cell& @CRLF & "Number of rows = " & $Num_Rows[3]) FileWriteLine($Insert_Fyle,"Insert into Reset_Tmp_CNUM (C_Num) values ('" & $Ctrl_No & "')" & @CRLF) $Record_Cnt = $Record_Cnt + 1 Next ; And finally we close out _ExcelBookClose($oExcel) FileClose($Insert_Fyle) MsgBox(4096,"Insert Create", "Insert file created -- " & $Record_Cnt & " records written!")

Hello! Sorry to intrude, but I'm having a problem with "_ExcelSheetUsedRangeGet". I reviewed the function comments and thought I was using it correctly, but... Here is the code that I'm using is below. I keep getting "0" returned for the last row number and I'm positive that there are 15 rows in the sheet. I apperciate any help I can get with this. Thanks & have a great, PJ Local $oExcel = _ExcelBookOpen($Get_In_Fyle, 1) Dim $Num_Rows[4] $CurrRow = 1 $Record_Cnt = 0 $Num_Rows = _ExcelSheetUsedRangeGet($oExcel, 1) SplashTextOn("DeBug","Last Cell Used " & $Num_Rows[0] & @CRLF & "Last Cell Used " & $Num_Rows[1] & @CRLF & "Last Col Used " & $Num_Rows[2] & @CRLF & "Number of rows = " & $Num_Rows[3], 500, 200, -1, 50, 4, "", 12) Sleep(300) MsgBox(4096,"DeBug", "Number of rows = " & $Num_Rows[3]) ; MsgBox(4096,"DeBug", "Control Number = " & $Ctrl_No) For $Cell = 1 to $Num_Rows[3] $Ctrl_No = _ExcelReadCell($oExcel, $Cell, 1) MsgBox(4096,"DeBug", "Control # = " & $Ctrl_No & @CRLF & "Cell # = " & $Cell& @CRLF & "Number of rows = " & $Num_Rows[3]) FileWriteLine($Insert_Fyle,"Insert into Reset_Tmp_CNUM (C_Num) values ('" & $Ctrl_No & "')" & @CRLF) $Record_Cnt = $Record_Cnt + 1 Next ; And finally we close out _ExcelBookClose($oExcel) FileClose($Insert_Fyle) MsgBox(4096,"Insert Create", "Insert file created -- " & $Record_Cnt & " records written!")