AIstarter

Hi, Thanks for your input. I'll take a look at it, meanwhile I've made a Drag and Drop solution including pre-saved images. Since I want to store the files in a sql database I'll have something to try with, while drag and drop is not the best way it's at least something I can work with.

Hello, I want to create a GUI where there are 2 field to capture a signature that is done with a signature/drawing pad and a pen - which just emulates a mouse. I'm not sure if this can be done, I found no information on this at all... Has somebody done this / seen this? Thanks!

The AutoFilter function. But I figured it out: Local $oSheet = __OOoCalc_GetSheet($oWorkbook, -1) $oRange = $oSheet.getCellRangeByPosition(0, 0, $Columns, UBound($aArray)).getRangeAddress() $oWorkbook.DatabaseRanges.addNewByName("Filters", $oRange) $oWorkbook.DatabaseRanges.getByName("Filters").AutoFilter = True This enables the AutoFilter for the selected Range.

Hi, I'm trying to set autofilter for a sheet - is this by any way possible with this udf? Thanks!

Fun Fact - I'm not able to reproduce this using the original Filename - but I'm still able to reproduce this somehow. I tried a lot of thing because it works now, but I found another way to get the same message... I tried a copy of my file named "AddConf New (5).au3" and with this filename I get the same message even if it's different. I'll try and get the debug log when I'm at home again tomorrow

Hi Jos, svn status gave And my ini looks nearly the same [Versioning] Versioning=SVN DiffPGM=C:\Program Files\WinMerge\WinMergeU.exe DiffPGMOptions=/wr Prompt_Comments=y [SVN] VersionPGM=C:\Program Files\TortoiseSVN\bin\svn.exe CommandChkVersioning=info "%sourcedir%" CommandChkVersioning_ok_txt=Working Copy Root Path: CommandChkVersioning_ok_rc= CommandStatusSource=status "%sourcefile%" -u CommandStatusSource_ADD_txt=\?\s*?%sourcefile% CommandStatusSource_ok_txt=[MA\?][\s\d-]*?%sourcefile% CommandLogSource=log "%sourcefile%" -l 5 CommandAddSource=add "%sourcefile%" CommandAddSource_ok_txt=A.*?%sourcefileonly% CommandAddSource_ok_rc= CommandCommitSource=commit "%sourcefile%" --message "%commitcomment%" CommandCommitSource_ok_txt= CommandCommitSource_ok_rc=0 CommandCommitSource_new_revision=(?i)(?s)committed revision\s*([0-9]*) CommandGetLastVersion=cat "%sourcefile%" CommandGetLastVersion_ok_txt= CommandGetLastVersion_ok_rc=0 Thanks! Edit: I think I found it... seems to be there are no whitespaces allowed for it to work. Using another filename with no whitespace it works. Any way to get around this?

Hi Jos, paneoutput attached

Hi, I'm having some problems with Autoit/Scite (reinstalled both of course) - my scite won't increase the FileVersion anymore on any of my projects and SVN says there is no difference - but TortosieSVN says the file is modified (I even added some lines of code and according to Scite it's still the same) #AutoIt3Wrapper_Res_Fileversion=1.4.3.4 #AutoIt3Wrapper_Res_FileVersion_AutoIncrement=y #AutoIt3Wrapper_Versioning=y #AutoIt3Wrapper_Versioning_Parameters=/comments "%scriptfile% %fileversion% \n" /NoPrompt I have no idea why it stopped working? Using the diff of TortosieSVN I see a LOT of changes in the file? Thanks in advance! Edit: Commiting using TortosieSVN works fine - svn update works fine. I doubt it's a SVN problem?

Would second the wish for Landscape for a book - I've switched from Excel to LO-Calc and miss this Edit: One thing I noticed: I can't overwrite with the SaveAs Function (despite setting Overwrite to True)

I'm using this to de-attach/re-attach files from/to EML Files so in my case it has nothing to do with Exchange (which i'm not using at all)

I would use it

I get the attachments Count (+ 1, think this is the email itself) via $oMessage.BodyPart.BodyParts.Count, but I don't manage to delete the attachment as the delete function takes another parameter (number or reference - might be able to work with number once I figure out if the mail itself is the first or last object) and actually save the eml file. On the other side I seem to be able to $oMessage.AddAttachment(@ScriptDir & "\1.pdf") (at least I don't get an error) - but https://msdn.microsoft.com/en-us/library/ms526130(v=exchg.10).aspx doesn't show a save method to write the .eml with the new attachment to disk? Edit2: Deleting seems to work, but I can't get the File to Save ConsoleWrite($oMessage.BodyPart.BodyParts.Count & @CRLF) $oMessage.BodyPart.BodyParts.Delete(2) ConsoleWrite($oMessage.BodyPart.BodyParts.Count & @CRLF) $oMessage.AddAttachment(@ScriptDir & "\1.pdf") ConsoleWrite($oMessage.BodyPart.BodyParts.Count & @CRLF) shows 3 in the first line and 2 in the second line, so Item 2 is deleted and 3 on the last line so the 1.pdf file is added Edit3: Nevermind... after taking a quick nap I found the reason I can't seem to save - I forgot to get the stream after chaning the Object... After manipulating the Attachments this works $oMessageStream = $oMessage.GetStream() $oMessageStream.Flush() ; this is essential $oMessageStream.SaveToFile(@ScriptDir & "\new.eml")

Hi, Any Chance of deleting or replacing an attachment with autoit? Extracting attachments works, but I want to replace the attachment afterwards in the eml File (or at least delete them). $oAttachment.Delete or $oAttachment.Delete() won't work - found the .delte function on an MS Page about the Message CDO and thought I might try it, but had no luck... Thanks in advance!

Did somebody ever got this working? Tried like posted above, a small progressbar appears for some miliseconds - but the script is not updated. Or any other alternatives? The Compiled Exe should update itself without asking if a new version is available (wether via web or path, but prefered via filepath)

Holy... damn & - I got used to this from Multine Messageboxes... And I could swear I saw them in the linked post, too. Now I see there weren't any The "(" came from copy/pasting the version with Brackets (like I said I tried a lot...) Thanks M23!

Hi, I've searched for threads were multine if were discussed. Found this one for Example: But my Multineline If is throwing errors. If I write it all in one line it works as expected, but I can't seem to break it down: If Not (StringRight($FileName[$i], 4) = ".txt" Or StringRight($FileName[$i], 4) = ".inf" Or StringRight($FileName[$i], 5) = ".zinf" Or StringRight($FileName[$i], 4) = ".pdf" Or StringRight($FileName[$i], 7) = ".pdf123" Or ($FileName[$i] = "test.mysql") Then I tried it like this, but I get error: Syntax Error on Ctrl+F5 in Scite on all Lines starting with Or If Not (StringRight($FileName[$i], 4) = ".txt" & _ Or StringRight($FileName[$i], 4) = ".inf" & _ Or StringRight($FileName[$i], 5) = ".zinf" & _ Or StringRight($FileName[$i], 4) = ".pdf" & _ Or StringRight($FileName[$i], 7) = ".pdf123" & _ Or ($FileName[$i] = "test.mysql") Then I even tried putting the StringRight = "..." in () like this: (StringRight($FileName[$i], 4) = ".inf") but this doesn't work. Help?! Thanks!

Hi Jos, I'll PM you a script today. The Problem is the main script. Thanks!

Hi, I just noticed that AU3Stripper messes up German Umlauts (äüö) - without AU3Stripper the Umlauts are correct. I have output.code.page=65001 and code.page=65001 - and my Files are UTF-8. I tried the latest Beta of AU3Stripper (I found a link somewhere in the Forums searching for this Problem) - but the Problem still exists. Changing #AutoIt3Wrapper_Run_Au3Stripper=y to n and there are no Problems with the Umlaute Bye!

Thanks @mLipok - i did read the changelog but didn't quite register what keyword meant. Checking for Null works of course.

Yes, I get null from SQL - that didn't change between AutoIT Versions and is still the same. But testing for null did change as it seems. In 3.3.8.1. a test for null works fine with just = "" - apparently this changed in new versions where you have to take a look at StringLen or String($var). That was my problem...

Indeed $var = String($var) works fine with = "" Did I miss something in the changelog? Or was is just a guess? Anyway, thanks a lot - I'll do a bit of code-rework now back to = "" with the String statement

Yes I did. I didn't notice anyhting regarding my problem. But declaring the var with "" as in your example should work in any case - since then it is indeed '""'. Even with a new script and just declaring Dim $var (without = "") works. In my case it's part of an array that comes back from am MSSQL query. This returns NULL - and it seems that this was handled in a different way? I tested my code on an old 3.3.8.1 installation and the same code (without StringLen) works perfectly. Strange?!

Hello, I recently upgraded from 3.3.8.1 to 3.3.14.2 and noticed something that doesn't make sense to me: I'm using a script to fetch records from an MSSQL Database. Some fields are empty (which is correct) and using 3.3.8.1 this works fine and sets $var2 to "something" If ($var = "") Then $var2 = "something" EndIf After upgrading to 3.3.14.2 this doesn't work anymore. The String has a length of zero (which is the way I use now as a workaround) If (StringLen($var) = 0) Then $var2 = "something" EndIf But I don't understand why this won't work anymore. Any Idea? Thanks!