cgasb

Also wanted to say that this fixed error code 50 on Exchange 2003 as well. Thanks

I get the same effect as Swift when trying Nov 10, 1970 or Nov 3, 1977. Choosing another month in either of these years works fine. Maybe something to do with November? Btw, I'm running WinXP and AutoIt v3.2.10.0.

That worked beautifully when I incorporated your adjustments. Thanks for the lesson.

I create an array with PC names and then populate a listview. I am currently getting the selected PC by using $GUI_EVENT_PRIMARYDOWN and GUICtrlRead in the corrosponding function, but that's not accurate as the function is activated by clicking anywhere in the GUI. ;============================================= ; Define some GUI stuff and display the GUI ;============================================= GUICreate("Computer List", 200, 250) ; will create a dialog box that when displayed is centered $PCView = GUICtrlCreateList (" ",17,17,120,200) GUISetOnEvent($GUI_EVENT_CLOSE, "CLOSEClicked") GUISetOnEvent($GUI_EVENT_PRIMARYDOWN, "Value") GUISetState () ;============================================= ; Setup the list with computer names ;============================================= For $z = 1 To $aPC[0] GUICtrlSetData(-1,$aPC[$z]) Next ;============================================= ; Idle around ;============================================= While 1 Sleep(1000) Wend ;============================================= ; Read the computer name that is selected and do something ;============================================= Func Value() $valuex = GUICtrlRead($PCView) MsgBox(0, "", $valuex) EndFunc ;============================================= ; Close the GUI and exit the program ;============================================= Func CLOSEClicked() Exit EndFunc What would be the "proper" way to grab what is clicked in the list?

That worked! Thanks so much for the help.

Thanks for the tip. I'll head down the StringSplit road and look forward to checking out the updates.

I am doing some work in an Access database using the ADO UDF. Using the function _accessQueryLike returns an array where the values are seperated by Chr(28). Ex: $aHuntCSR = _accessQueryLike($sFilePath, $sWMTable, $sWGDN, $iCSR) _ArrayDisplay($aHuntCSR, "") returns this: [0]|11 [1]|6704108472 [2]|670402029 [3]|670412030 [4]|670422031 [5]|670432032 [6]|670442033 [7]|670467006 [8]|670472047 [9]|670487009 [10]|670497068 [11]|6704117012 I am having a time figuring a good way to sort by the second column (determing the largest value would also work for me). The one with 10,0,1,2,3 etc. Is there a way to sort this type of array like that? Many thanks for the help!

I figured out why I was getting zeros instead of formula results (typo on the R1C1 location). I could still use some help with the dates though. This is a snippet: #include <ExcelCOM_UDF.au3> ; Include the Excel collection #include <Array.au3> ; Include the Array collection $FilePathONE = FileOpenDialog("Select the first file", "", "Excel files (*.xls;*.xlsx;*.csv)", 1) ;browse for the XLS file If @error Then MsgBox(4096,"","No File chosen") exit EndIf $oExcelONE = _ExcelBookOpen($FilePathONE, 0) ;open the chosen XLS file $sExcelTitleONE = $oExcelONE.Name & " - " & $oExcelONE.ActiveWorkbook.Name ;Get window title $sExcelSheetONE = _ExcelSheetNameGet($oExcelONE) ;get the active sheet name $val = _ExcelReadCell($oExcelONE, 3, 4) Msgbox(0,'Cell value as seen by AutoIT',$val) _ExcelBookClose($oExcelONE, 0,1) If I read a cell with a date, for example 1/15/2005, then $val will = 20020115000000 Is there a way when using _ExcelWriteCell to write the date back using slashes, rather than 20020115000000? Thanks for the advice.

When I read a column of dates in Excel using _ExcelReadArray and then write those values to a new sheet I get "20050128000000" instead of "1/28/2005". What should I be looking at to get the preferred formatting back? My second question is about reading cells that contain formulas. When I use _ExcelReadArray on a column of formulas I get "0" when I insert the new cell. Is that a limitation of ExcelCOM_UDF or is there a way to carry the resultant value over. Thanks for the advice!

Thanks, this is great. These additions/changes made it more user friendly for me: $FilePath = FileOpenDialog("Select the new file", "", "All files (*.*)", 1) ;browse for the image file If @error Then MsgBox(4096,"","No File chosen") exit EndIf $miDoc.Create($FilePath)

Thanks for info; you got me on the right track. This seems to work well: WinWaitActive("[TITLE:; CLASS:SunAwtDialog]", "")

I am opening a window in a java app that takes varying amounts of time to appear. The window has no title and no visible or hidden text. It has a Basic Window Info Class: SunAwtDialog. It also has a Basic Control Info Class: SunAwtCanvas, with instances of 2 and 7. Is there any way I can wait for this window other than using sleep()? Thanks for the help. WinActivate("TotalPlus - []") Send("!{F9}") WinWaitActive(?????)