Quantumation Posted January 5, 2016 Share 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 Link to comment Share on other sites More sharing options...
TheDcoder Posted January 5, 2016 Share 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 Link to comment Share on other sites More sharing options...
water Posted January 5, 2016 Share 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 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
Quantumation Posted January 5, 2016 Author Share 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. Link to comment Share on other sites More sharing options...
orbs Posted January 5, 2016 Share 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 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 Link to comment Share on other sites More sharing options...
kcvinu Posted January 5, 2016 Share 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) Link to comment Share on other sites More sharing options...
TheDcoder Posted January 5, 2016 Share 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 Link to comment Share on other sites More sharing options...
orbs Posted January 5, 2016 Share 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 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 Link to comment Share on other sites More sharing options...
kcvinu Posted January 5, 2016 Share 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) Link to comment Share on other sites More sharing options...
TheDcoder Posted January 5, 2016 Share 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 Link to comment Share on other sites More sharing options...
Quantumation Posted January 5, 2016 Author Share Posted January 5, 2016 @orbs No worries, I wouldn't make something that I wouldn't share with everyone. Link to comment Share on other sites More sharing options...
TheDcoder Posted January 5, 2016 Share 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 Link to comment Share on other sites More sharing options...
orbs Posted January 5, 2016 Share 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 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 Link to comment Share on other sites More sharing options...
Quantumation Posted January 5, 2016 Author Share 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. Link to comment Share on other sites More sharing options...
TheDcoder Posted January 5, 2016 Share 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 Link to comment Share on other sites More sharing options...
water Posted January 5, 2016 Share 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 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
water Posted January 5, 2016 Share 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 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
water Posted January 5, 2016 Share 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 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
Quantumation Posted January 5, 2016 Author Share 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. Link to comment Share on other sites More sharing options...
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