Home Creators Posts Import Register Favorites Logout

Content

Hello Members,

The training we have for this week that I have shared with you was about the Software & License Manager. If you have not seen it yet, you can view it right here on YouTube.

Now that the training has been released, I am looking for your feedback to make this even better, just for you, our incredible Patreon Members.

So, what Feature can I add for you? Did you find an issue you want me to fix? Or is there a particular area you would like me to focus on?

Please comment your ideas and feedback to any of these below and I will do my best to not only create an updated workbook but release a private training video next Monday, right here on Patreon.

I am looking forward to hearing from you and thanks so much for your support.

Regards,

Randy

Files

Learn How To Create A Secure Licensing System For Your Excel Software [FREE DOWNLOAD]

📢JOIN US ON PATREON FOR UNRELEASED TRAININGS + MORE ► https://bit.ly/PatreonDesc 👉JOIN MY MENTORSHIP PROGRAM - EARN PASSIVE INCOME► http://bit.ly/MentorProgram_YTDesc 🔥 GET 200 OF MY BEST TEMPLATES WITH PDF VBA CODEBOOKS HERE► https://bit.ly/MyBestWorkbook 👨‍💼JOIN MY INCREDIBLE DASHBOARD MASTERCLASS HERE► http://bit.ly/Dashboard_YTDesc 📣NEW TO VBA? TAKE THIS COURSE TODAY ► https://bit.ly/VBACourse_Discount In this week’s training, I will show you how to create your own excel-based software licensing system so you can secure and sell your excel applications. ⬇DOWNLOAD THIS WEEKS WORKBOOK FREE: 📩 USING YOUR EMAIL: http://bit.ly/LicMgr_WkbkDl 💬 FACEBOOK MESSENGER: http://bit.ly/LicMgr_FbDld GET MAKE/INTEGROMAT FOR FREE HERE: https://bit.ly/IntegromatAutomation EXCEL COURSES: ►DASHBOARD MASTERCLASS: http://bit.ly/Dashboard_YTDesc ►MENTORSHIP PROGRAM: http://bit.ly/MentorProgram_YTDesc ►BEGINNERS VBA COURSE: https://bit.ly/FreeVBACourse EXCEL PRODUCTS: ►The Ultimate Excel Resource Guide: http://bit.ly/UERG_YTDesc ►200 Excel Workbooks: https://bit.ly/MyBestWorkbooks ►Convert Excel Into A Secure EXE File: http://bit.ly/SecureExcel ►Automate Your VBA Programming: https://bit.ly/AutoMacroAddIn ►Create Dashboards & Charts in Seconds: https://bit.ly/Pine-Bi ►Find the Best Excel Products & Courses Here: http://bit.ly/ExcelProducts Timestamps: 0:00 - Introduction 0:28 – Overview 17:00 – Add New License 28:47 – Set Expire Date License 34:11 – Save and Update License 36:52 – Saved Message License 38:05 – Clear Filter License 39:53 – List Load License 40:22 – Change Event Worksheet 45:04 – Selection Change Event Worksheet 49:30 – Load License 51:04 – Delete License 59:39 – Add Update License Data 1:10:48 – Click Existing Key 1:11:46 – Click New Registration 1:14:18 – Click Send Button 1:14:44 – Register and Check License 1:37:55 – Secure and Close Workbook 1:38:47 – Open Workbook JOIN OUR COMMUNITY: ►Facebook Group: http://bit.ly/groupexcel ►Facebook Fan Page: https://bit.ly/EFF_FanPage Follow me on my Social Media Accounts: 🐦Twitter: https://twitter.com/Excel4Freelance 🌏Website: https://www.ExcelForFreelancers.com 🔗LinkedIn: https://www.linkedin.com/in/excelforfreelancers/ 👤Facebook: https://www.facebook.com/ExcelForFreelancers/ 📸 Instagram: https://www.instagram.com/excelforfreelancers/ 🎥Rumble: https://rumble.com/c/ExcelForFreelancers 👤Locals: https://locals.com/member/ExcelFreelancers ✉Telegram: https://t.me/ExcelForFreelancers 📲Gab: https://gab.com/ExcelForFreelancers About Us: I help Microsoft Excel enthusiasts turn their passion into profits so they can earn passive income using their skills without having to trade time for money. I love making these videos for you each and every week. A great way of supporting Excel For Freelancers to keep these training free each and every week is by supporting us through one of the amazing products offered that will help you skyrocket your Excel Skills and reach your dreams. Get Alerted IMMEDIATELY with new Free Training Videos & Workbook by subscribing here: 👉 https://www.youtube.com/c/ExcelForFreelancers/ New Training Video Uploaded every Tuesday! Thank you very much for your continued support, Randy Austin

Comments

p l

anyone else having problems with date formats, spent over 14 hours on this problem testing the integromat formats in the datastore and out to the text string, a lot of trial and error tracking down the format problems. basically excel inbound to integromat gets reversed, month and day wise. of anyone has worked out a bullet proof work around it would be nice to know. also having problem with the parsing of the dropbox txt file, reg date is in text format imported into excel opposed to date format

Robert Burton

Are you formatting the dates the way you want with Integromat? I format the dates in the Dropbox Create/Overwite module and it work fine. But yuou have to get the syntax right! formatDate(FieldName;MM-DD-YYYY) is what works for me. make sure you get the Capitalization correct on the formatDate or it wont work.

Excel For Freelancers

Robert is correct, formatting the dates in the Dropbox Create/Overwrite Text field body with the format he mentioned will make sure dates come through properly. Also make sure that in our Data Store you have set the column as a Date type column In next weeks Feature, Fix or Focus video training I will put special attention on this area. Thanks so much for the question.

p l

thx will test out our recommendations..... I am also going to add some code which shows the machine id so people can't just keep registering for free 30 day trials, at least with the same machine. will have to add an additional column but suspect that should be straight forward.

Excel For Freelancers

Yes Machine ID is a great feature. You can also run a check on each open against that machine ID to see if it has changed (If they move the computer you can then ask them if they want to change the license ID to the new computer) So that the old one is removed and the new one is added. This allows users to change computers without adding new computers. Another possibility is to add additional computer licenses with the Same license key. I go over all of this in my Mentorship course. Thanks again.