Quantumation Posted January 5, 2016 Posted January 5, 2016 I'm new to scripting and Autoit, but i've already found some things that I would like to create. Where do you start when creating a UDF?For instance, if I wanted to make a UDF for Excel(I know one exists) Where would I start? What would I need to start researching?Any input would be appreciated
TheDcoder Posted January 5, 2016 Posted January 5, 2016 https://www.autoitscript.com/wiki/UDF-spec EasyCodeIt - A cross-platform AutoIt implementation - Fund the development! (GitHub will double your donations for a limited time) DcodingTheWeb Forum - Follow for updates and Join for discussion
water Posted January 5, 2016 Posted January 5, 2016 I depends:Do you want to make an UDF just for yourself or should it be useful for the community as well? 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
Quantumation Posted January 5, 2016 Author Posted January 5, 2016 @water Useful for the community.I'd definitely make it for myself but of course i'd share the hell out of it. Autoit has become my new addiction so i'm looking to get real deep into her business.@TheDcoder Thank you, looks like i've got plenty of reading material.............Perfect.
orbs Posted January 5, 2016 Posted January 5, 2016 I depends:Do you want to make an UDF just for yourself or should it be useful for the community as well?i doubt that's a beneficial segregation. if you train yourself to write a fully-qualified UDF, following all formal standards, then it will also be very much easier for yourself to use, develop and troubleshoot, even if you never share it. also it is much easier for the community to help you with your UDF when written by the standards. Signature - my forum contributions: Spoiler UDF: LFN - support for long file names (over 260 characters) InputImpose - impose valid characters in an input control TimeConvert - convert UTC to/from local time and/or reformat the string representation AMF - accept multiple files from Windows Explorer context menu DateDuration - literal description of the difference between given dates WinPose - simultaneous fluent move and resize Apps: Touch - set the "modified" timestamp of a file to current time Show For Files - tray menu to show/hide files extensions, hidden & system files, and selection checkboxes SPDiff - Single-Pane Text Diff Magic Math - a math puzzle Demos: Title Bar Menu - click the window title to pop-up a menu
kcvinu Posted January 5, 2016 Posted January 5, 2016 (edited) @orbs ,I think water's comment is the result of his curiosity. Because, he is the master mind behind current excel udf. So he want to know what is lacking in the current excel udf. Edited January 5, 2016 by kcvinu Spoiler My Contributions Glance GUI Library - A gui library based on Windows api functions. Written in Nim programming language. UDF Link Viewer --- A tool to visit the links of some most important UDFs Includer_2 ----- A tool to type the #include statement automatically Digits To Date ----- date from 3 integer values PrintList ----- prints arrays into console for testing. Alert ------ An alternative for MsgBox MousePosition ------- A simple tooltip display of mouse position GRM Helper -------- A littile tool to help writing code with GUIRegisterMsg function Access_UDF -------- An UDF for working with access database files. (.*accdb only)
TheDcoder Posted January 5, 2016 Posted January 5, 2016 he is master mind behind current excel udf. So he want to know what is lacking the current excel udfIs he a thief or something? EasyCodeIt - A cross-platform AutoIt implementation - Fund the development! (GitHub will double your donations for a limited time) DcodingTheWeb Forum - Follow for updates and Join for discussion
orbs Posted January 5, 2016 Posted January 5, 2016 (edited) @kcvinuindeed, but the OP does not know that, and water's hint may well lead him astray. Edited January 5, 2016 by orbs kcvinu 1 Signature - my forum contributions: Spoiler UDF: LFN - support for long file names (over 260 characters) InputImpose - impose valid characters in an input control TimeConvert - convert UTC to/from local time and/or reformat the string representation AMF - accept multiple files from Windows Explorer context menu DateDuration - literal description of the difference between given dates WinPose - simultaneous fluent move and resize Apps: Touch - set the "modified" timestamp of a file to current time Show For Files - tray menu to show/hide files extensions, hidden & system files, and selection checkboxes SPDiff - Single-Pane Text Diff Magic Math - a math puzzle Demos: Title Bar Menu - click the window title to pop-up a menu
kcvinu Posted January 5, 2016 Posted January 5, 2016 @orbs , Yeah, that's true. @TheDcoder , What ? Does that word means like that ?. Oh my poor English. I just meant that, that udf is water's brain child. Spoiler My Contributions Glance GUI Library - A gui library based on Windows api functions. Written in Nim programming language. UDF Link Viewer --- A tool to visit the links of some most important UDFs Includer_2 ----- A tool to type the #include statement automatically Digits To Date ----- date from 3 integer values PrintList ----- prints arrays into console for testing. Alert ------ An alternative for MsgBox MousePosition ------- A simple tooltip display of mouse position GRM Helper -------- A littile tool to help writing code with GUIRegisterMsg function Access_UDF -------- An UDF for working with access database files. (.*accdb only)
TheDcoder Posted January 5, 2016 Posted January 5, 2016 @kcvinu Was joking kcvinu 1 EasyCodeIt - A cross-platform AutoIt implementation - Fund the development! (GitHub will double your donations for a limited time) DcodingTheWeb Forum - Follow for updates and Join for discussion
Quantumation Posted January 5, 2016 Author Posted January 5, 2016 @orbs No worries, I wouldn't make something that I wouldn't share with everyone.
TheDcoder Posted January 5, 2016 Posted January 5, 2016 @Quantumation Remember that UDF-spec is not complete, some exceptions can be made EasyCodeIt - A cross-platform AutoIt implementation - Fund the development! (GitHub will double your donations for a limited time) DcodingTheWeb Forum - Follow for updates and Join for discussion
orbs Posted January 5, 2016 Posted January 5, 2016 also, here is another good resource from the AutoIt Wiki.https://www.autoitscript.com/wiki/User_Defined_Functions Signature - my forum contributions: Spoiler UDF: LFN - support for long file names (over 260 characters) InputImpose - impose valid characters in an input control TimeConvert - convert UTC to/from local time and/or reformat the string representation AMF - accept multiple files from Windows Explorer context menu DateDuration - literal description of the difference between given dates WinPose - simultaneous fluent move and resize Apps: Touch - set the "modified" timestamp of a file to current time Show For Files - tray menu to show/hide files extensions, hidden & system files, and selection checkboxes SPDiff - Single-Pane Text Diff Magic Math - a math puzzle Demos: Title Bar Menu - click the window title to pop-up a menu
Quantumation Posted January 5, 2016 Author Posted January 5, 2016 @orbs Bookmarked and queued for reading@TheDcoder I'll play by the rules until I figure out how to break them.
TheDcoder Posted January 5, 2016 Posted January 5, 2016 @TheDcoder I'll play by the rules until I figure out how to break them.Nice one Quantumation 1 EasyCodeIt - A cross-platform AutoIt implementation - Fund the development! (GitHub will double your donations for a limited time) DcodingTheWeb Forum - Follow for updates and Join for discussion
water Posted January 5, 2016 Posted January 5, 2016 i doubt that's a beneficial segregation. if you train yourself to write a fully-qualified UDF, following all formal standards, then it will also be very much easier for yourself to use, develop and troubleshoot, even if you never share it. also it is much easier for the community to help you with your UDF when written by the standards.Not just curiosity.If I would have to write an UDF just for myself I'm sure I would try to adhere to the standards when writing (naming of variables etc.). But I'm sure I wouldn't invest as much time into writing the help file and examples. As I have written the UDF I'm very familiar with the subject and do not need as much explanation and examples as a newbie.That's why I asked. kcvinu 1 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
water Posted January 5, 2016 Posted January 5, 2016 (edited) @orbs ,I think water's comment is the result of his curiosity. Because, he is the master mind behind current excel udf. So he want to know what is lacking in the current excel udf.No, my question was of general nature. Not related to my Excel/ExcelChart/Word/Outlook/PowerPoint UDF But I'm always open for suggestions on how to improve the "official" UDFs. Edited January 5, 2016 by water kcvinu 1 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
water Posted January 5, 2016 Posted January 5, 2016 @kcvinu Was joking May I remind you that this isn't the Chat forum? 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
Quantumation Posted January 5, 2016 Author Posted January 5, 2016 May I remind you that this isn't the Chat forum?Dang @water's not messing around.Guys quick, comment suggestions for training and I mean some top notch ideas.......like at least a 5/7.
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