JCarson

Just wondering where development is on this and what the method of getting involved in helping with development is. Let me know and thanks in advance. Joe

I haven't posted a lot to the forums and am not trying to necro the topic, but saw some things I might put my 2 cents in on. First, I have no problem creating zip-compatible files using the update or add functions of this UDF, as in they open under WinZip 10 no problem, I believe the key is designating a file with a zip extension. Second, I have been using the UDF from the below post and the newest custom-built DLL compatible with COM interfaces found at http://www.csdinc.co.jp/archiver/lib/7-zip32.html#download I would take the time to add more functions to the UDF or design one that uses the standard DLL, but I neither have the time nor the experience necessary at this point. I would like to fully explore what the DLL can and cannot do as to various formats in the future. I will post here if I find anything further. Thank you.

My $0.02. I am currently using a conglomeration of OutlookEX and the Outlook UDFs. I do find this UDF useful, even to the extent of possibly assisting to improve it / add features. Admittedly, right now, I'm using it as a glorified Rules script, but it is still helpful. Thanks again, Carson

Doesn't seem to work for me. Windows XP SP3 Outlook 2003 (all known updates) Outlook is in cached exchange mode .. I don't really have a choice in this. Thank you, Carson

Out of morbid curiosity, has anyone attempted to connect to and OPC server using this code? Thanks, Carson

Thank you both for your replies. I may PM the either of you in the future to determine more direction. How much is needed to keep the site up and running bandwidth and server wise? Thank you again, Joe

Been using the software for years, lurking on the forum for more years .. relatively new to the whole participation thing. Was wondering if there was anywhere to go from here, or do we basically have everything we need in AutoIT? Open discussion, not wanting to start anything if mods feel that the post will cause an issue, wouldn't take it personally if it was deleted. Thanks again, Joe

I'd like to give this a go, just one question. Can you get route information (time, etc) for a route with multiple destinations? Thanks in advance, Carson

So, one of the components for a script I'm writing might need to access other computers, not just Windows, some telnet, some VT100 emulated sessions, maybe some linux if I get bored .. in short a big batch of evil. Clear text is bad. Encrypting with an easily accessible key is bad. Encoding in the code of the program bad. Using a hash and a salt, storing the actual credentials in a secure database and using the hash to grab the credentials from said database .. one step away from bad. I could go on. The community's $0.02 is deeply appreciated. This would run on a Windows system yet access others through LAN/WAN/Serial, just need a way to store the goodies. Carson

I would love to see continued development on this. One of my major wishes is for nested folders, anyone else want to see this?

I have been using PrimalScript for some time to limited success. I have searched the forums and have some leads, but would very much enjoy some handholding in establishing a completely portable no install / USB Drive IDE and snippet environment for my AutoIT scripting. Thank you in advance, Joe

There are several ways to script for Outlook, but I'd like to settle on AutoIT. Is there a method, without using the Redemption object(s) to get an AutoIT script to be a trusted application? Thank you in advance.

Thank you, I appreciate both your comments, this gives me some sense of tranquility with going forward with my script. Thanks again ! Joe

Understandable in theory as indicated by google .. but in practice, does anyone have an opion on reliability of this method or a different one that they have found workable ? Thanks again, Joe

I have written a script to store the file length and md5 hash of a file in a database for the purposes of eliminating duplicate files. I have googled around and am looking for any input from the community as to the probability that two files with the same length would generate the same MD5 file hash. I am not opposed to using SHA1 which has a much lower incidence of possible collision. Any input would be appreciated. Thank you, Joe

Apologies, despite my status on this forum, I do try to search before posting. For the record on the benefits of AutoIT, my previous solution was VBA code and was taking about 2 hours despite using "manual calculation" and "update=false" tricks amongst other things. To testify to the benefit of AutoIT, adapting the same logic of the VBA, once I changed the Excel Read/Write functions, yielded returned results in 3-6 minutes .. a 20-40x speed increase.

Alas, not enough posts to post in the "Example Scripts Forum". This is by no means a finished script, simply a quick fix as I could feel my beard grow waiting for excel files to load. My hope is that the Excel UDF would be updated with similar code. This requires the Array2D include. These are simply a modification of the same functions in Excel UDF to allow for more of a "copy and paste" as opposed to the 1 cell at a time that was being done. This affects whole sheets only, although I figure that someone with more time than I can adapt those two functions to take advantage of this for all the variances of the function. Verified working with latest non-beta AutoIT, Windows XP SP2 with all subsequent updates and Excel 2003. Let me know if it is of any help, Carson Func _ExcelWriteSheetFromArray2($oExcel, ByRef $bArray) $AARRAY = $BARRAY _ARRAY2D_DELETE($AARRAY, 0, 1) _ARRAY2D_DELETE($AARRAY, 0, 2) _ARRAY2D_TRANSPOSE($AARRAY) With $OEXCEL.Activesheet .Range(.Cells(1, 1), .Cells(UBound($AARRAY, 2), UBound($AARRAY, 1)) ).Value = $AARRAY EndWith Return 1 EndFunc Func _ExcelReadSheetToArray2($oExcel, $iStartRow = 1, $iStartColumn = 1, $iRowCnt = 0, $iColCnt = 0, $iColShift = False) Local $avRET[1][2] = [[0, 0]] ; 2D return array ; Test inputs If Not IsObj($oExcel) Then Return SetError(1, 0, 0) If $iStartRow < 1 Then Return SetError(2, 0, 0) If $iStartColumn < 1 Then Return SetError(2, 1, 0) If $iRowCnt < 0 Then Return SetError(3, 0, 0) If $iColCnt < 0 Then Return SetError(3, 1, 0) ; Get size of current sheet as R1C1 string ; Note: $xlCellTypeLastCell and $x1R1C1 are constants declared in ExcelCOM_UDF.au3 Local $sLastCell = $oExcel.Application.Selection.SpecialCells($xlCellTypeLastCell).Address(True, True, $xlR1C1) ; Extract integer last row and col $sLastCell = StringRegExp($sLastCell, "\A[^0-9]*(\d+)[^0-9]*(\d+)\Z", 3) Local $iLastRow = $sLastCell[0] Local $iLastColumn = $sLastCell[1] ; Return 0's if the sheet is blank If $sLastCell = "R1C1" And $oExcel.Activesheet.Cells($iLastRow, $iLastColumn).Value = "" Then Return $avRET ; Check input range is in bounds If $iStartRow > $iLastRow Then Return SetError(2, 0, 0) If $iStartColumn > $iLastColumn Then Return SetError(2, 1, 0) If $iStartRow + $iRowCnt - 1 > $iLastRow Then Return SetError(3, 0, 0) If $iStartColumn + $iColCnt - 1 > $iLastColumn Then Return SetError(3, 1, 0) ; Check for defaulted counts If $iRowCnt = 0 Then $iRowCnt = $iLastRow - $iStartRow + 1 If $iColCnt = 0 Then $iColCnt = $iLastColumn - $iStartColumn + 1 ; Size the return array ReDim $avRET[1][$iColCnt + 1] $avRET[0][0] = $iRowCnt $avRET[0][1] = $iColCnt If $iColShift Then ;Added by litlmike ; Read data to array For $r = 1 To $iRowCnt For $c = 1 To $iColCnt $avRET[$r][$c - 1] = $oExcel.Activesheet.Cells($iStartRow + $r - 1, $iStartColumn + $c - 1).Value Next ProgressSet(($r/$iRowCnt)*100,"","Completed " & int(($r/$iRowCnt)*100) & "%") Next Else ;Default for $iColShift With $oExcel.Activesheet $avRET2=.Range(.Cells(1,1),.Cells($iRowCnt,$iColCnt)).Value _Array2D_Transpose($avRET2) _Array2D_Insert($avRET2,0,"",2) _Array2D_Add($avRET, $avRET2) $avRET2="" endwith EndIf ;Return data Return $avRET EndFunc