NerdAct Posted August 22, 2022 Posted August 22, 2022 Dear Autoit Community, I am planning to use Autoit to automate updating my excel files everyday, basically this is a routine boring job that I am required to do therefore I thought to Automate it but I have some questions: From where should I start learning Autoit scripting? Is there a life tutorial that would help me here? I read about Autoit Au3recorder, which is a great tool!! is there a way to download it and use it here? Is there anyone would assist me and help me writing my project? Can't wait for your help guys as there are no much resources about Autoit :) Regards,
Musashi Posted August 22, 2022 Posted August 22, 2022 5 minutes ago, NerdAct said: I am planning to use Autoit to automate updating my excel files everyday Take a look at the Excel_UDF A good introduction into AutoIt is provided by the wiki and the Help (+examples), that were installed together with AutoIt. "In the beginning the Universe was created. This has made a lot of people very angry and been widely regarded as a bad move."
water Posted August 22, 2022 Posted August 22, 2022 The Excel UDF is documented here. If you run into problems, post here and we will do our best to assist you My UDFs and Tutorials: Spoiler UDFs: Active Directory (NEW 2024-07-28 - Version 1.6.3.0) - Download - General Help & Support - Example Scripts - Wiki ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki Task Scheduler (2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs: Excel - Example Scripts - Wiki Word - Wiki Tutorials: ADO - Wiki WebDriver - Wiki
Moderators Melba23 Posted August 23, 2022 Moderators Posted August 23, 2022 Moved to the appropriate forum. Moderation Team Any of my own code posted anywhere on the forum is available for use by others without any restriction of any kind Open spoiler to see my UDFs: Spoiler ArrayMultiColSort ---- Sort arrays on multiple columnsChooseFileFolder ---- Single and multiple selections from specified path treeview listingDate_Time_Convert -- Easily convert date/time formats, including the language usedExtMsgBox --------- A highly customisable replacement for MsgBoxGUIExtender -------- Extend and retract multiple sections within a GUIGUIFrame ---------- Subdivide GUIs into many adjustable framesGUIListViewEx ------- Insert, delete, move, drag, sort, edit and colour ListView itemsGUITreeViewEx ------ Check/clear parent and child checkboxes in a TreeViewMarquee ----------- Scrolling tickertape GUIsNoFocusLines ------- Remove the dotted focus lines from buttons, sliders, radios and checkboxesNotify ------------- Small notifications on the edge of the displayScrollbars ----------Automatically sized scrollbars with a single commandStringSize ---------- Automatically size controls to fit textToast -------------- Small GUIs which pop out of the notification area
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now