Leaderboard

I can attest this statement. As a retired man with no technical background, I was immensely helped by @TheXman and, in fact, many others in this community to learn coding from scratch and build some useful tools of my own. I highly respect those who are willing to help others.

Note: This is the continuation thread from the original one of 2012. The old one growed over 50 pages...so to make the overview better i created a new main thread for the ISN AutoIt Studio. You can find the old original thread here. The ISN AutoIt Studio is a complete IDE made with AutoIt, for AutoIt! It includes a GUI designer, a code editor (with syntax highlighting, auto complete & intelisense), a file viewer, a backup system and a lot more features!! Here are some screenshots: Here are some higlights: Easy to create/manage/public your AutoIt projects! Integrated GUI-Editor (ISN Form Studio 2) Integrated file & projectmanager Auto backupfunction for your Projects Extendable with plugins! Available in several languages Trophies Syntax highlighting /Autocomplete / Intelisense Macros Changelog manager for your project Detailed overview of the project (total working hours, total size...) Am integrated To-Do List for your project Open Source (You can download the source code from my website) And much much more!!! -> -> Click here to download ISN AutoIt Studio <- <- Here is the link to the german autoit forum where I posted ISN AutoIt Studio the first time: Link For more information visit my Homepage: https://www.isnetwork.at So, have fun with the ISN AutoIt Studio! And feel free to post your feedback, bugreports or ideas for this project here in this thread!

In this thread, it was asked if there was a Date Range Picker somewhere. Couldn't find one. With @Zedna calendar with @maniootek proposal, I felt it could be fun to create one. So here it is. Like always, if you have some suggestions, I am open to any. Version 2022-04-10 *Window drag can now be performed anywhere with the background of the GUI (non-control space) * Clicking on the month label, select the whole month Version 2020-12-05 * Standardized presentation of month calendar where column 1 is Sunday and column 7 is Saturday. Version 2020-11-04 * Dates selection using Shift-Click inside a single month or between months * Auto-multi lingual Hope you like it. Date Range Picker.au3

Does anyone familiar with working with objects have any idea why it might be throwing COM errors? Google API doesn't have any samples that make sense to convert to use Google Sheets in Autoit. _Example() Func _Example() Local $oErrorHandler = ObjEvent("AutoIt.Error", "_ErrFunc") #forceref $oErrorHandler ;---- From https://scand.com/products/gspread/ ; $sName - User name, any you like ; $sClientIdAndSecret - "client_id|client_secret" format ; example client id: 292085223830.apps.googleusercontent.com ; $sScriptId - Google Apps script ID ; https://docs.microsoft.com/en-us/office/vba/api/excel.application.maillogon $sName = "Owner" $sClientIdAndSecret = "myclientidString|myclientSecret" ; from generate client_id.json $sScriptId = "myappscriptidString" Local $oApp = ObjCreate("GSpreadCOM.Application") $oApp.MailLogon($sName, $sClientIdAndSecret, $sScriptId) ;$oApp.Workbooks.Item("Example2").Worksheets.Item("Sheet1").Activate() EndFunc ;==>_Example Throws the following errors: GoogleSheetsTest.au3 (16) : ==> COM Error intercepted ! err.number is: 0x800401F3 err.windescription: Invalid class string err.description is: err.source is: err.helpfile is: err.helpcontext is: err.lastdllerror is: 0 err.scriptline is: 16 err.retcode is: 0x00000000 GoogleSheetsTest.au3 (17) : ==> COM Error intercepted ! err.number is: 0x000000A9 err.windescription: Variable must be of type 'Object'. err.description is: err.source is: err.helpfile is: err.helpcontext is: err.lastdllerror is: 0 err.scriptline is: 17 err.retcode is: 0x00000000 GoogleSheetsTest.au3 (18) : ==> COM Error intercepted ! err.number is: 0x000000A9 err.windescription: Variable must be of type 'Object'. err.description is: err.source is: err.helpfile is: err.helpcontext is: err.lastdllerror is: 0 err.scriptline is: 18 err.retcode is: 0x00000000 >Exit code: 0 Time: 0.09846

@seadoggie01 Yes, that is the intended behavior. You can set the $lForce parameter to True in this scenario where there isn't any existing driver instance and you want to force the download to occur. Glad you're enjoying the UDF and I appreciate your contributions as well.

RetiredGuy has a need, and the AutoIT is incidental - he wants to download his historical comments from the Washington Post. They deliberately make their site hard to access behind a paywall, and of course their underlying data is not going to be exposed for scraping, easily. There are a lot of concepts to learn here: Accessing your comments at the website, downloading them, storing them, and presenting them in a format you need. You have to understand HTML, Javascript, CSS, templates, and how the data is stored and accessed as the browser builds the page that it displays to you, and what you have to do to intercept that. Break your problem down into smaller chunks, and then solve them one-by-one, building on what you have learnt. It is glaringly obvious from the posts above that you have a long way to go, but I sense that you have time, patience, and a purposeful persistence that will win out in the end. Show that you have mastered the concept of downloading what is displayed to you before you initiate the 'more' command, and then you can build on that, and I am sure those watching will jump in to offer suggestions. Explain the steps on paper, before you start coding in any language at all. How do you build a table of those articles that have your comments attached and ignore the rest? How you access only your comments amongst all the others? How you download them? What format do you store them in? How do you sort them and present them? Once you can explain that to your mother-in-law or a teenager (that cannot code) so they can understand it in plain English, then you will find that your code will most likely automagically fall into place. Correspondingly, nobody feels obligated to spoon feed you. Experiment with what you observe, Read about how they want to help you at https://www.washingtonpost.com/view-your-comment-history-on-the-my-profile-tab/d1ec02fd-b3db-44a5-9c45-c66be29323ff_note.html Research a little on GitHub on what others have done, mostly with other languages other than AutoIT. What did those programmers do to solve the challenges? How did they approach it? The actual code is not that important for your research at the initial stages - the underlying concepts are. Google search is your friend (sorta), as long as you know what questions to ask. Use trigger words like 'screen scrape', 'script', etc and slowly it will fall into place. Just firing off code that you have cut and pasted from examples will not help you unless you understand the concepts behind what it is there for - why each command is being invoked, how it works, and what the end results are. Unfortunately that is something you have to do for yourself. We can offer suggestions, but you still have to put in the hard yards to reap the rewards. Once you have mastered the fundamentals, the rest is relatively easy! Best of luck. PS> I started with punch cards and worked my way forwards. Other than programming a VCR, I still can show those cheeky upstarts a thing or two! Learning is a lifetime challenge, whether formal or not. Never get bored - get even! Persistence vs enthusiasm - experience always wins. Structured learning however where you learn the fundamentals that apply across all languages is something that I would strongly recommend. There are a lot of courses online these days that are free, and find one that is compatible with your learning style. Most universities and colleges offer them. Well worth doing.

Hi everybody mikell kindly shared with me his 2nd regex version for adding thousands separators. This 2nd version takes care of negative numbers too. I told him that his regex was important for the AutoIt community and it should really find its place in the Forum. So with his permission, I post his code & comments concernant the \G anchor. All credits are his, when he started with version 1 in this link ; mikell's thousands separator version 2 (november 2020) $sInput = "-10024000.22345" $sOutput = StringRegExpReplace($sInput, '\G([+-]?\d+?)(?=(\d{3})+(\D|$))', '$1,') MsgBox(0, "mikell wiz \G - Result before and after", $sInput & @CRLF & $sOutput) #cs How \G works : \G is an anchor which matches at the beginning of the subject string or at the end of the previous match. In this case it is used as a "forced failure" tool : 1. first \G matches at the beginning of the string 2. then the regex searches for ("+" or "-" (optional) and one or more digits) followed by (one or more 'packs' of 3 digits and a non-digit or the end of string). "-10" matches 3. \G matches right after "-10", the regex restarts searching from this position in the same way than 2. and "024" is found 4. \G matches right after "024", the regex keeps on searching but the condition in 2. is not fulfilled any more, so the regex fails and the final result is returned #ce

BTW: The OutlookEX UDF does not automate the UI (User Interace) of Outlook but uses the Microsoft API (COM) to access incoming mails etc. I do not think it is a good idea to have such automation run on the server. The main purpose of an Exchange server is to provide a service for many, many users. it should not be overcharged with other tasks. If the automation tasksbrings the server to a halt (eats up all CPU, memory or disk space etc.) all users are affected. If this happens on a client automating Outlok then just one user is affected. This seems to be a good reading what MS intends: https://techcommunity.microsoft.com/t5/exchange-team-blog/upcoming-changes-to-exchange-web-services-ews-api-for-office-365/ba-p/608055 Graph overview: https://docs.microsoft.com/en-us/graph/overview?view=graph-rest-1.0

And even if it were criticism, this objection is very justified. Au3toCmd is a solution where only one file is needed on the target system. The desktop shortcut is just an added bonus. In contrast, your solution requires three files. Autoit.exe, anyname.a3x and a cmd file for the call. As the saying goes, many roads lead to Rome.

A regex way $sInput = "1234567890.1234567" $sOutput = StringRegExpReplace($sInput, '\G(\d+?)(?=(\d{3})+(?:\D|$))', '$1,') MsgBox(0, "Result before and after", $sInput & @crlf & $sOutput)