Here is the bare bones of a UDF I have started work on.
Mostly just a proof of concept at this stage, and still need to add some functions and dress the UDF up a bit ... to look like a UDF ... though it has my own distinct styling, especially as I have never really developed a UDF before now .... used plenty and modified plenty though. I've even invented my own UDF variable naming convention, which I am sure some of you will be aghast at. I work with what feels best for me, but others are free to adapt if they wish.
The idea is to emulate the simplicity of INI files, but gain the benefits of SQL.
Two scripts are provided.
(1) The UDF, a work in progress - SimpleSQL_UDF.au3
(2) An example or testing script - UDF_Test.au3
Another first for me, is creating a 2D array from scratch, never done that before, that I can recall ... never had a need, and even for 1 dimension arrays, for a long time now, I have just used _StringSplit to create them. So I needed a bit of a refresher course, which my good buddy @TheDcoder assisted me with ... not without some angst I might add. LOL
Program requires the sqlite3.dll, not included, but easily enough obtained.
Hopefully the usage is self-evident ... just change the Job number variable in the UDF_Test.au3 file to check the existing functions out.
P.S. This is also related to a new program I have just finished and uploaded - INItoSQL DB
as a start in Autoit i tried something i was missing since im using Autoit.
I build a custom MessageBox which has a large amount of custom options and which scales its size on the parameters you set.
-Text Color (Buttons, Text)
-Background Color (Msgbox, Buttons, Label)
-Icon (Default, No Icon, Custom)
-Label/ Button Style.
I tried to keep this as close as i could to a Msgbox i was used too on my batch times.
After i was ready i realised, @Melba23 probably build a way better msgbox which would have suit my needs enterly, anyway thanks to @Melba23 because i use his Stringsize UDF.
local $Message = _sMsgBox("Test", 6, "Continue?") if @extended <> -1 Then MsgBox(0, @extended, $Message&" Button pressed")
I am working on a project where, emails from outlook are to be read and moved to various folders within the mailbox, based on the content of the emails.
I used the below code for moving mails. It works fine when I run it against individual mail ids. But when I run it on Shared mailbox, the mails are not moved to respective folders.
_OL_ItemMove($oOutlook, $sEntryId, Default, $sDestinationFolder) The value of $sEntryId is saved in an excel report initially. The current process reads the $sEntryId from the excel and passes it to "_OL_ItemMove" statement.
Requesting the guidance of the forum members in this issue.
Good evening everyone
I am working with Word UDF ( thanks @water! ), and, especially, with the function _Word_DocFindReplace().
The replace does work everywhere in the document, but, it does not work in Headers or Footers.
Am I missing something or am I forced to use the code below?
I have already looked in the Help file ( about _Word_DocFindReplace() ), but there are no mentions about replace text in Headers/Footers.
Sub FindAndReplaceFirstStoryOfEachType() Dim rngStory As Range For Each rngStory In ActiveDocument.StoryRanges With rngStory.Find .Text = "find text" .Replacement.Text = "I'm found .Wrap = wdFindContinue .Execute Replace:=wdReplaceAll End With Next rngStory End Sub Thanks everyone in advance
7/8/2018: Uploaded a new SciTe4AutoIt3.exe v18.708.1148.0 installer.
It has been over a year since the last update of the full SciTE4AutoIt3 installer whch mainly had to do with the fact that Neil was moving toward v4 of SciTE and I wanted to wait for a stable version.
Any help with testing this version before general release is appreciated.
Also any feedback is welcome in caseI missed something or suggestions for improvement before releasing.
==> SciTE4AutoIt3 v18.708.1148.0
Addition/Changes/Fixes in the current installer:
-------------------------------------------------------------------------------------------------- 8-7-2018 *** Merged the SciTE v 4.1.0 by Neil Hodgson with our own version of SciTE. (Jos) This is a major change from the previous version so ensure you update all files including LUA or else you will get errors! - SciLexer au3: Fixed issues with nested CommentBlocks not always showing the correct color. - SciLexer au3: Change any line starting with # and no recognised keyword to be shown with the Pre-Processor in stead of default. - Changed Shortcut for AU3INFO to Ctrl+Shift+F6. - Moved the session restore logic for (save.session.advanced=1)into SciTE in stead of LoadSession.lua as that was clearing the recent files list of the last session when opening a file by double cliking it. This is fixed with this change. Default remains 0 so when a file is double clicked the last session isn't restored unless you add this to SciTEuser.properties: "save.session.advanced=1" - updated Tools.lua replacing [s%] with [ /t] to avoid empty lines being stripped by those functions. (Thanks Enyby) *** Updated AutoIt3Wrapper v18.708.1148.0 (Jos) - 17.224.935.1 Added /autoit3dir to au3stripper commandline, when provided to AutoIt3Wrapper., to ensure the included files are for the correct AutoIt3 directory - 17.224.935.2 Added directives: #AutoIt3Wrapper_Res_CompanyName= ;Company field #AutoIt3Wrapper_Res_LegalTrademarks= ;Trademark field - 17.224.935.5 Fixed Versioning when files contain backets -> () - 17.224.935.6 Added support for : #AutoIt3Wrapper_Au3stripper_Stop_OnError= ;(Y/N) Continue/Stop on Warnings.(Default=N) - 17.224.935.7 added INI support for: [Other] Au3Stripper_Stop_OnError=n - 17.224.935.10 Minor changes in console messages - 17.224.935.11 Modifications from JPM: - add #AutpIt3Wrapper_Res_Cursor_Add - "clean" a little bit AutoIt3Wrapper.au3 *** Updated Au3Stripper v18.708.1148.0 (Jos) - 17.224.935.1 Fixed crash when an include file contains longer record than 4096 characters. - 17.224.935.2 Changed /rsln to replace @ScriptLineNumber in the Master script with "XXX/YYY". XXX is the master script linenumber, YYY is the Merged script linenumber. - 17.224.935.3 Fixed issue detecting #cs #ce when a space was missing after the directive. - 17.224.935.4 Changed Close/Open logic for Tracelog to (hopefully) avoid the hardcrash. - 17.224.935.5 improved speed avoiding rereading include files to determine the max rec len. - 17.224.935.6 improved speed by re-coding the check for long records. - 17.224.935.7 Made sure the returncode is the highest from all iterations in stead of the last iteration. - 17.224.935.8 fix for reported bug: https://www.autoitscript.com/trac/autoit/ticket/3623#comment:4 - 17.224.935.9 added support for #autoit3wrapper_autoit3dir - 17.224.935.10 Fixed support for #autoit3wrapper_autoit3dir when followed by linecomment Stop processing when include file isn't found. - 18.624.1847.1 strip the leading and trailing double quotes from the autoit3dir directive to avoid an error when they are specified. - 18.624.1847.2 Fixed Hardcrash in the Include logic - 18.624.1847.3 Fixed Hardcrash in Func stripping logic by enlarging the base table size - 18.702.1556.1 Fixed regression bug with the Translate option. - 18.703.1808.2 Fixed regression bug with the Stripping FUNC logic for the first found FUNC. *** Updated SciTEConfig v18.708.1148.0 (Jos) - 17.224.935.1 No updates *** Updated Tidy v18.708.1148.0 (Jos) - 17.224.935.1 Added option to copy comments from #CS to #CE. Default is to copy the comments. Added Tidy Parameters: /Skip_CE_Comment or /scec will skip this copy action Added INI option: * * * Add comment to #CE/#CommentEnd and make it the same as the #CS/CommentStart Comments. ce_comment=1 - 17.224.935.2 Fix issue with Copy comments on comment start - end - 17.224.935.4 Fix another issue with Copy comments on comment start - end -------------------------------------------------------------------------------------------------- ==> ScitillaHistory page containing all SciTE-Scintilla updates.
==> Visit the SciTE4AutoIt3 Download page for the latest versions
==> Check the online documentation for an overview of all extra's you get with this installer.