No video

How To Secure AND License Your Excel-Base Software & Applications [FREE DOWNLOAD]

  Рет қаралды 128,253

Excel For Freelancers

Excel For Freelancers

Күн бұрын

Пікірлер: 342
@ExcelForFreelancers
@ExcelForFreelancers 3 ай бұрын
🔥Download 350 Of The Worlds Best Templates Here ► rebrand.ly/350Wkbks_YTPinnedCom
@alanpowell24
@alanpowell24 2 жыл бұрын
Randy works so hard and is so disciplined with his output. He deserves to succeed !
@ExcelForFreelancers
@ExcelForFreelancers 2 жыл бұрын
Thanks so very much Alan. I do appreciate that :) :)
@joemanflyer2001
@joemanflyer2001 22 күн бұрын
This would help all those independent software developers like you !
@ExcelForFreelancers
@ExcelForFreelancers 21 күн бұрын
Absolutely. Thanks so much Joe
@craigmorrison6526
@craigmorrison6526 2 жыл бұрын
I'm truly amazed that you are sharing this particular training in this channel Randy .... I cant wait for this one .... This being the case, my goodness, what must you be offering in the mentorship program .... ?? See you on Tuesday ....
@ExcelForFreelancers
@ExcelForFreelancers 2 жыл бұрын
Exactly Craig, This is just about 10% of what I have in the Mentorship Program. I am sure you will love what is inside. This is a small taste. I know you will enjoy the training. Thanks again Craig.
@craigmorrison6526
@craigmorrison6526 2 жыл бұрын
Hay Randy, I'll be in meetings all afternoon so can't make the live premier. I'll be sure to catch is later though. I can't wait!
@Quran_Translation_Official
@Quran_Translation_Official 2 жыл бұрын
I like the company . Believe in Your success this year. Carefully following Your development, I joined the project and will strongly support this project.
@ExcelForFreelancers
@ExcelForFreelancers 2 жыл бұрын
Thank you so very much, I really appreciate that Asif
@floeru12
@floeru12 Ай бұрын
Amazing Video! Thank you so much!
@ExcelForFreelancers
@ExcelForFreelancers Ай бұрын
Thank you so very much, I really appreciate that
@slminc
@slminc Жыл бұрын
I combined this application with the one-click update - what a breeze. One centralised workbook for all my freelance jobs.
@ExcelForFreelancers
@ExcelForFreelancers Жыл бұрын
Oh that is really smart. The combination will work very well
@slminc
@slminc Жыл бұрын
The logical approach is key in development of VBA Applications
@ExcelForFreelancers
@ExcelForFreelancers Жыл бұрын
Absolutely. Thanks so much Sammy
@ianhenderson1974
@ianhenderson1974 2 жыл бұрын
Fantastic tutorial. Now I need to learn the integromat portion. Thank you Randy
@ExcelForFreelancers
@ExcelForFreelancers 2 жыл бұрын
Glad it was helpful and thanks so much Ian. Thank you for your Likes, Shares & Comments. It really helps.
@gazimedyatv1111
@gazimedyatv1111 Жыл бұрын
I want to use this licensing system. First of all, I downloaded the free excel file you shared. I updated the necessary database settings. Now I want to license another excel file with this method. Which of the vba codes in this free version should I transfer to the file to be licensed? I will be glad if you can help me with this code. Thank you very much.
@ExcelForFreelancers
@ExcelForFreelancers Жыл бұрын
Hi and thanks very much. Please make sure to transfer the codes within the licensing module. Also make sure to watch the entire training, as many times as needed, in order to understand how to apply that code to other workbooks. I hope this helps and thanks so much.
@mokterail123
@mokterail123 2 жыл бұрын
I am your very big fan of you and follower, I am watching all your Videos, which is very useful and gaining for more knowledge with your videos.Believe in Your success this year. Carefully following Your development, I joined the project and will strongly support this project
@ExcelForFreelancers
@ExcelForFreelancers 2 жыл бұрын
Thanks so much. Very kind of you Mokter
@bestscenes1469
@bestscenes1469 2 жыл бұрын
Such an amazing guru. I can't wait for it.
@ExcelForFreelancers
@ExcelForFreelancers 2 жыл бұрын
Thank you so very much, I really appreciate that. I am sure you will love this one.
@redtee946
@redtee946 3 ай бұрын
I can't thank you enough !!!!
@ExcelForFreelancers
@ExcelForFreelancers 3 ай бұрын
For sure, you are very welcome. I am happy to help and share
@adamshults9810
@adamshults9810 Жыл бұрын
Wow! The introduction to integromat was exactly what I needed. On another note, I notice you use static cell references ("A1") rather than named ranges in your code. Named ranges help me to modify by workbooks without breaking my code but then there are several named ranges perhaps you wouldn't want the client to see. Just curious about your thoughts on the matter. Thanks for the great content.
@ExcelForFreelancers
@ExcelForFreelancers Жыл бұрын
I am using named ranges more and more these days, even with a single cell since its also easier to read in the code. As long as your workbook stays fast, I would say go ahead and create named ranges for everything as it helps for the reasons you have mentioned. Named ranges can also be hidden as well. I hope this helps and thanks so much.
@veerapandij2536
@veerapandij2536 2 жыл бұрын
Hello Mr.Randy… I am your very big fan of you and follower, I am watching all your Videos, which is very useful and gaining for more knowledge with your videos 👍…
@ExcelForFreelancers
@ExcelForFreelancers 2 жыл бұрын
Thank you so very much, I really appreciate that. :)
@cabbaaz
@cabbaaz Жыл бұрын
"Hi Randy! I hope this comment finds you well. I've been following this Training and it went good but one thing i was unable to do was to do the "intogremat scenarios" so if it is not your problem i would like you to share with me both of your scenarios and i would be so grate full. Thanks for always helping us ?
@ExcelForFreelancers
@ExcelForFreelancers Жыл бұрын
HI and thanks for your comment. I am glad you enjoyed the training. Due to my schedule, I am unable to offer any one-on-one consulting. However can you please post your request in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel and mark it as a PAID JOB. We have 60,000 Members who would love to help you with this. You may also want to contact Make/Integromat for support. Thanks so much.
@vishalgohil931
@vishalgohil931 2 жыл бұрын
Fantastic. Thank you very much for this trick. Nobody else was able to explain this.
@ExcelForFreelancers
@ExcelForFreelancers 2 жыл бұрын
For sure, you are very welcome Vishal
@haroldluciano5203
@haroldluciano5203 2 жыл бұрын
Thanks Randy for the nice tutorial...live watching now.
@ExcelForFreelancers
@ExcelForFreelancers 2 жыл бұрын
For sure, you are very welcome. Thank you for your Likes, Shares & Comments. It really helps.
@saqlainshaikh9936
@saqlainshaikh9936 2 жыл бұрын
Randy Sir you are amazing thanks a lot
@ExcelForFreelancers
@ExcelForFreelancers 2 жыл бұрын
Thank you so very much, I really appreciate that Shaikh
@H-do8tr
@H-do8tr 2 жыл бұрын
GREAT as usual! 😍 How can I use this software with XLS PadLock?
@ExcelForFreelancers
@ExcelForFreelancers 2 жыл бұрын
HI and thanks you can install xls padlock, then browse for this file on your computer and then create an exe from it. You can find more details on the xlxpadlock website. I hope this helps and thanks so much.
@jonnoedge167
@jonnoedge167 2 жыл бұрын
Can't wait for this, this channel is the best for Excel & VBA. Legends!!
@ExcelForFreelancers
@ExcelForFreelancers 2 жыл бұрын
Thank you so very much, I really appreciate that Jonno
@Dalimscreative
@Dalimscreative 2 жыл бұрын
Fantastic tutorial
@ExcelForFreelancers
@ExcelForFreelancers 2 жыл бұрын
Thanks so much. Very kind of you. Thank you for your Likes, Shares & Comments. It really helps.
@t-seriesapp4967
@t-seriesapp4967 2 жыл бұрын
Interesting tutorial. I can't wait to have it.
@ExcelForFreelancers
@ExcelForFreelancers 2 жыл бұрын
Thanks so much George. I know you will really enjoy it.
@catherinesecreto8956
@catherinesecreto8956 2 жыл бұрын
This is great Randy! Can't wait for it! 💚
@ExcelForFreelancers
@ExcelForFreelancers 2 жыл бұрын
thank you so very much Catherine :)
@khuranav6
@khuranav6 6 ай бұрын
Hey Randy, you did a fantastic job on this problem i really appreciate your work, I've seen very carefully your video and followed all the steps but somehow i am getting an error in app_macros module with " Line Input #1, LicData" can you help me with solving this error and also my dropbox is remaining empty else is working perfectly when i input the data it's get updated on make, Thanks in advance and loved your work once again.
@ExcelForFreelancers
@ExcelForFreelancers 6 ай бұрын
Hi , Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.
@tier1athlete829
@tier1athlete829 2 жыл бұрын
Randy this is awesome. If the end user is using a MAC would this work if the creator of the excel workbook is using windows to develop the program.
@ExcelForFreelancers
@ExcelForFreelancers 2 жыл бұрын
Hi and thanks, this should work on a Mac or PC, however there may need to be a few customizations for file paths on a Mac. I hope this helps and thanks so much.
@supermou
@supermou Жыл бұрын
Thanks Randy, Tha's a great video to share. To make sure that I understood it correctly, at the end we will end up with two different files: First one will be send to customer which will include the " Start " page only while the other file will include a the other sheets customized to fit my application and the complete set of Macros should be dragged into the both files? I'm I right? Many thanks in advance.
@ExcelForFreelancers
@ExcelForFreelancers Жыл бұрын
Yes that is correct. One of the files will be your application in which you send to the customer and the other will be another which allows you to control everything as an admin. I hope this helps and thanks so much.
@nazirulislam2491
@nazirulislam2491 2 жыл бұрын
This is very helpful video. Thanks for sharing the video.
@ExcelForFreelancers
@ExcelForFreelancers 2 жыл бұрын
For sure, you are very welcome. Thank you for your Likes, Shares & Comments. It really helps.
@VS-rh8rq
@VS-rh8rq 2 жыл бұрын
GREAT TUTORIAL. i assume this can be done Google sheets as well, publish then connections to excel in hidden sheet provided it is for small business network. ENJOYED IT. THANKS
@ExcelForFreelancers
@ExcelForFreelancers 2 жыл бұрын
Hi and thanks, this is only for Excel however there may be ways to do it in Google Sheets as well. Thank you for your Likes, Shares & Comments. It really helps.
@craigslist4428
@craigslist4428 Жыл бұрын
I’m looking for best practices with error handling. It’s not an obvious feature just looking at the template types. Do any of your files have error handling?
@ExcelForFreelancers
@ExcelForFreelancers Жыл бұрын
HI Craig, thanks for your comment. I cover a little bit in each video, however, I will add it to my list of videos to create in the near future. I hope this helps and thanks so much.
@PatrickAngwin
@PatrickAngwin 7 ай бұрын
Hi, this looks great! Just one question: could this be used to license add-ins or just entire workbooks? Many thanks.
@ExcelForFreelancers
@ExcelForFreelancers 7 ай бұрын
Hi and thanks very much. This is just for workbooks however I will be creating an entire course on how to lock, license and launch your excel applications or add-ins very soon. I hope this helps and thanks so much.
@tier1athlete829
@tier1athlete829 Жыл бұрын
Would this fully function using a MAC & if user is running the workbook on a MAC? Can this properly function if putting program into a exe file with XLS Padlock? How does it work to secure it with only working on 1 computer & can’t be shared with others? Like for this to fully function on windows & a Mac without having to use XLS Padlock
@ExcelForFreelancers
@ExcelForFreelancers Жыл бұрын
Hi and thanks, Mac's do not run ActiveX controls, so Mac's are very limited when it comes to Excel features. I wish it was not the case. Thank you for your Likes, Shares & Comments. It really helps.
@alaminhossen1518
@alaminhossen1518 2 жыл бұрын
This is absolutely beautiful advice
@ExcelForFreelancers
@ExcelForFreelancers 2 жыл бұрын
Thank you very much. So nice of you Shimu
@mohamedelfounti4484
@mohamedelfounti4484 Жыл бұрын
Great Video as always! Amazing! Is it also possible to tie a specific workbook to the Users computer? Can you please provide me the download link please? The link isn't active anymore. I will consider to join you mentorship program.
@ExcelForFreelancers
@ExcelForFreelancers Жыл бұрын
Hi and thanks so much. Yes it is possible to tie a specific computer to a specific license, so its not a problem. I did check on both download links and they work fine so please try again, and if you are still having issues you can check with my assistant Shane shane@ExcelForFreelancers.com Within the Mentorship program i am teaching the licensing in my greater detail along with assigning a license to a computer to it cannot be used on another www.excelforfreelancers.com/product/excel-for-freelancers-mentorship-program/ I hope this helps. Should you have any additional questions, please do not hesitate to ask.
@Phemelocutie
@Phemelocutie 2 жыл бұрын
Hello Mr Andy, with your amazing licensing software, if a customer register the application for 6 months, then saves the application many times for their different files, would they be using one licence number for all their files? And what happens if the license expires? Will they loose all the workbooks for their files? Pls advise. Thank you
@ExcelForFreelancers
@ExcelForFreelancers 2 жыл бұрын
Hi and thanks, you can use a special code to set this to a single machine so that it cannot be used on multiple machines (such as computer ID) and the date is checked on open so they cannot use it if the current date is newer than the expire date. They would not lose their workbook however access to it would be limited (based on whatever access you want them to have) I teach this in much more detail in my Mentorship Program here www.excelforfreelancers.com/product/excel-for-freelancers-mentorship-program/ I hope this helps and thanks so much.
@bashirdhali9372
@bashirdhali9372 2 жыл бұрын
Good and absolutely amazing advice
@ExcelForFreelancers
@ExcelForFreelancers 2 жыл бұрын
Thank you very much, I really appreciate that Bashir.
@samahnation
@samahnation 2 жыл бұрын
Halo Randy! Does the applications connected to licensing needs internet every time the user needs to use them?
@ExcelForFreelancers
@ExcelForFreelancers 2 жыл бұрын
Hi and thanks. the way it is programmed now, it is not required. Only when they register it or need to upgrade their licenses, otherwise internet is not required. I hope this helps and thanks so much.
@raselparvez9532
@raselparvez9532 2 жыл бұрын
Thanks sir for your good explanation
@ExcelForFreelancers
@ExcelForFreelancers 2 жыл бұрын
For sure, you are very welcome Rasel
@gazimedyatv1111
@gazimedyatv1111 Жыл бұрын
Hello, Thank you very much for the information. Honestly, it's great that you shared with us exactly the features I was looking for. There is something I don't understand here. Which macros do we need to copy to the file to be licensed? I couldn't find this anywhere.
@ExcelForFreelancers
@ExcelForFreelancers Жыл бұрын
Hi and thanks very much for your comment and I am glad you enjoyed the training. You would need all of the macros to create a proper licensing system, so please drag and drop the modules into your own application, then customize it accordingly. You may want to watch the training again in order to understand all of the concepts. I hope this helps and thanks so much.
@gazimedyatv1111
@gazimedyatv1111 Жыл бұрын
@@ExcelForFreelancers Thank you for your answer. There are three macros, I need to copy all three of them to another excel book. When I do it this way, when opening the file I want to license, it will ask for a license code, is it correct?
@ExcelForFreelancers
@ExcelForFreelancers Жыл бұрын
Hi and thanks you also want to make sure to copy the sheets over as needed and make sure to follow the training exactly as i have laid out. If you run into a specific issue, please post the screenshots, and all of the details in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.
@carlycarlyle
@carlycarlyle Жыл бұрын
Thanks for the video very nice work. I have a question. How would you prevent someone from just opening the workbook and editing the code to get around the expiry or to make the workbook fully visible?
@ExcelForFreelancers
@ExcelForFreelancers Жыл бұрын
Hi and thank you can lock the VBA code with a password. I cover lots of security options in this training: kzfaq.info/get/bejne/hL5-dJWm3qndeqM.html I hope this helps and thanks so much.
@ChristiaanRoest79
@ChristiaanRoest79 7 ай бұрын
The problem is that these passwords can be easily removed with tools​@@ExcelForFreelancers
@MahabubAlam-ek8be
@MahabubAlam-ek8be 2 жыл бұрын
This is absolutely amazing advice
@ExcelForFreelancers
@ExcelForFreelancers 2 жыл бұрын
Thank you so very much, I really appreciate that Mahabub
@RichardNickyBrian
@RichardNickyBrian Жыл бұрын
I am really impressed of this video. Wow you did well, God bless you for your effort. IF I may ask Randy does it also work with MS Access? I need help. Thanks
@ExcelForFreelancers
@ExcelForFreelancers Жыл бұрын
Hi and thanks so much, Richard. I have not worked with Access, however the VBA would be similar. Thank you for your Likes, Shares & Comments. It really helps.
@RichardNickyBrian
@RichardNickyBrian Жыл бұрын
@@ExcelForFreelancers Thanks again for your feedback my Mentor. I much appreciate you a lot. Bless you.
@ExcelForFreelancers
@ExcelForFreelancers Жыл бұрын
Its no problem, I am happy to help and share Richard
@SyedMuzammilMahasanShahi
@SyedMuzammilMahasanShahi 2 жыл бұрын
Thank you Randy for this amazing video.
@ExcelForFreelancers
@ExcelForFreelancers 2 жыл бұрын
For sure, you are very welcome and thanks for your continued support.
@supermou
@supermou Жыл бұрын
Hey Randy, Hope you have a great day. I'm missing something, I have been trying many times to link the sheet into my application but for some reason the webhooks is not connecting to the data store after testing. I copied the webhook into both Registration and Application Modules Is it right they should have the same Webhooks? As per your sheet there were two different hooks. Also, I moved the registration forms and its module into the application and the other modules should be kept in the application software manager file? Thanks in advance. Appreciate your support always.
@ExcelForFreelancers
@ExcelForFreelancers Жыл бұрын
Hi there, Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. I also teach this process in detail in my Mentorship Program here www.excelforfreelancers.com/product/excel-for-freelancers-mentorship-program/ I hope this helps and thanks so much.
@closeuptrading
@closeuptrading Жыл бұрын
hi randy, love the video this is exactly what I was looking for, I dod have a question, what about sharing licenses, can the application be open with the same license at the same time? thank you for your video
@ExcelForFreelancers
@ExcelForFreelancers Жыл бұрын
Hi Daniel, thanks for the great question. That is up to you, If you want to have multiple users per license, then you can set it for that, if not, you can limit it to a single user per license. I hope this helps and thanks so much.
@closeuptrading
@closeuptrading Жыл бұрын
@@ExcelForFreelancers thanks for the replay how is this is set up on the video /download version
@ExcelForFreelancers
@ExcelForFreelancers Жыл бұрын
HI and thanks so much. I teach this in detail in my Mentorship program here: www.excelforfreelancers.com/product/excel-for-freelancers-mentorship-program/ Thank you for your Likes, Shares & Comments. It really helps.
@josemiguelbaztan9607
@josemiguelbaztan9607 6 ай бұрын
Thank you Randy. Is there a way to generate the registration process after payment received automatically?
@ExcelForFreelancers
@ExcelForFreelancers 6 ай бұрын
Hi and thanks. Yes this can be automated. I show you how to do this in my Mentorship course here www.excelforfreelancers.com/product/excel-for-freelancers-mentorship-program/ I hope this helps and thanks so much.
@mdriajul8669
@mdriajul8669 2 жыл бұрын
Absolutely amazing advice 🥰🥰
@ExcelForFreelancers
@ExcelForFreelancers 2 жыл бұрын
Glad you think so and thanks so much
@lmt125
@lmt125 2 жыл бұрын
Ohh wow this will help scale and protect ⬆️⬆️⬆️
@ExcelForFreelancers
@ExcelForFreelancers 2 жыл бұрын
Yes now doubt. I am happy to share and help. Thanks again.
@ramishamali2745
@ramishamali2745 Жыл бұрын
Amazing one Randy... instead of drop box, what option should i pick to use MSFT One Drive?
@ExcelForFreelancers
@ExcelForFreelancers Жыл бұрын
HI and thanks very much Ramish. Yes you can use any shared folder application you like. I hope this helps and thanks so much.
@ramishamali2745
@ramishamali2745 Жыл бұрын
@@ExcelForFreelancers there are many option and i am not sure which one is the right one..... Get a file, upload a file, move a file...etc.
@ExcelForFreelancers
@ExcelForFreelancers Жыл бұрын
HI and thanks if you want to add a text file you can use Upload file. With that said, if you want to make it easier on yourself. Create a free Drobpox account so you can follow the training exactly. I hope this helps and thanks so much.
@RichardNickyBrian
@RichardNickyBrian 2 ай бұрын
Hello Sir Randy, I want to ask can someone cheat this license method by (1) just changing the system clock backwards and (2) tempering with the system registry values. Does any of them affect this method? Thank you.
@ExcelForFreelancers
@ExcelForFreelancers 2 ай бұрын
Hi and thanks very much. There is no system that is full-proof and completely secure. If someone wants to break your software, they will. Its better to just focus on creating software people want, making a lot of money, and forgetting about worrying about people who will break your software. If i had worried so much about that, i would never have created anything. I hope this helps and thanks so much.
@RichardNickyBrian
@RichardNickyBrian 2 ай бұрын
@@ExcelForFreelancersWow, this is a great word for me Randy, I am really blessed with this your word. As you say so, I move on by this words in mind. Thank you very much for your time, helping us to skill and much more. I appreciate you madly. God bless you and stay bless Sir Randy.
@ExcelForFreelancers
@ExcelForFreelancers 2 ай бұрын
For sure, you are very welcome and I am happy to help and share.
@walternhabanga
@walternhabanga Жыл бұрын
I'm having problems linking my data to make (intergromat). I'm having this error: TypeError Cannot read properties of undefined (reading 'datastore')
@ExcelForFreelancers
@ExcelForFreelancers Жыл бұрын
Hi Walter, Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.
@ylkardokum2780
@ylkardokum2780 Жыл бұрын
Hello, very nice work, thank you. How are we going to apply this licensing program to our ecxel project? Could you describe it please?
@ExcelForFreelancers
@ExcelForFreelancers Жыл бұрын
HI and thanks I share that with you in my Mentorship course here: www.excelforfreelancers.com/product/excel-for-freelancers-mentorship-program/ I hope this helps and thanks so much.
@chumkiisrat3065
@chumkiisrat3065 2 жыл бұрын
Absolutely amazing
@ExcelForFreelancers
@ExcelForFreelancers 2 жыл бұрын
Thanks so much. Very kind of you Chumki
@guelaboy2233
@guelaboy2233 2 жыл бұрын
Wooow thankx Lord, i can't wait to have it💻
@ExcelForFreelancers
@ExcelForFreelancers 2 жыл бұрын
For sure, you are very welcome Guela. Thank you for your Likes, Shares & Comments. It really helps.
@elmadawygames6677
@elmadawygames6677 6 ай бұрын
thanks for the course randy, can you send me the integromat template or Json file because I have problem with adding the functions and variable. thank you for your help
@ExcelForFreelancers
@ExcelForFreelancers 6 ай бұрын
Hi, you can download this file using the links in the description under the word DOWNLOAD. I hope this helps and thanks.
@elmadawygames6677
@elmadawygames6677 6 ай бұрын
can you send it here because i can't find it here, so i wish you send the json file here it will be very help ful for me if you did, thank you randy @@ExcelForFreelancers
@ExcelForFreelancers
@ExcelForFreelancers 6 ай бұрын
Hi and thanks very much. I only have the download workbook available and nothing else. I hope this helps and thanks so much.
@sorolvision7986
@sorolvision7986 2 жыл бұрын
Nice video good video.
@ExcelForFreelancers
@ExcelForFreelancers 2 жыл бұрын
Thank you so very much, I really appreciate that Sorol
@tier1athlete829
@tier1athlete829 2 жыл бұрын
When I copy the Start tab over into my own excel workbook it doesn’t bring over the words & register application button. What am I doing wrong? Can the marks program that is used with the excel process be completely utilized with the free plan?
@ExcelForFreelancers
@ExcelForFreelancers 2 жыл бұрын
Can you please share your issue, and screenshots, in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 50,000 Members who would love to help you with this. Thanks so much.
@gordenhildebrand8184
@gordenhildebrand8184 2 жыл бұрын
Thanks I wanna get into electronic soft.
@ExcelForFreelancers
@ExcelForFreelancers 2 жыл бұрын
Thanks so much. Very kind of you Gorden
@kunalchangoiwala7474
@kunalchangoiwala7474 2 жыл бұрын
If you could kindly guide on how to use such licensing system to share and protect pdf, mp4, other file formats..
@ExcelForFreelancers
@ExcelForFreelancers 2 жыл бұрын
Hi and thanks so much. I am focused on Excel training only for this time. I hope this helps and thanks so much.
@chadmonson8608
@chadmonson8608 Жыл бұрын
Hi Randy. When I refresh in the License Manager, the dropbox file disappears. I don't know if it is a Make setting or in the code?
@ExcelForFreelancers
@ExcelForFreelancers Жыл бұрын
HI and thanks, within the code, once files are processed they are removed from the folder. This is part of the macro. Make sure to watch the entire training video to see how this process works. I hope this helps and thanks so much.
@jessy_199x8
@jessy_199x8 2 жыл бұрын
Thankyou for the tutorial :))
@ExcelForFreelancers
@ExcelForFreelancers 2 жыл бұрын
For sure, you are very welcome Jessy
@m.elbanna
@m.elbanna Жыл бұрын
Hello Mr. Randy , I admire your work Sir, and you are doing a great job, but there is a problem with the license application here, When we click "Refresh" Button to bring the new license from the txt file to know who else activated "our App". , the "license application" replace the first license from the list we have with the new license we bring it by the "refresh" button . you can check the video here at the minute 14:22 , we have license for "Barry Johnson" as the first license in the list, and at the minute 14:25 after clicking the refresh button we can see "Barry Johnson" replaced with the new one "Jim Johnson". I have the same problem, Can you please tell us how to fix this. Thank you so much , appreciate your help ..
@ExcelForFreelancers
@ExcelForFreelancers Жыл бұрын
Hi and thanks. Please make sure a new row is assigned using the .Range("A99999").end (xlup).row + 1 I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
@m.elbanna
@m.elbanna Жыл бұрын
@@ExcelForFreelancers Thank you for your response, Actually yeah the code for this part in "CheckForNewLicenseData" was : If LicRow = 0 Then LicRow = .Range("A99999").End(xlUp).Row + 1 I Change it to " If LicRow 0 Then " LicRow = .Range("A99999").End(xlUp).Row + 1 and it works fine now , but I want your opinion as you are the expert. thank you so much.
@ExcelForFreelancers
@ExcelForFreelancers Жыл бұрын
HI and thanks, youc an try to change the formula to something like Iferror(Match(B2,Lic_ID,0)+3,0) I don't remember the exact formula but instead of the "" at the end, try to change it to 0 then you can keep the following: If LiceRow = 0 then LicRow = .Range("A99999").End(xlUp).Row + 1 I hope this helps and thanks so much.
@m.elbanna
@m.elbanna Жыл бұрын
@@ExcelForFreelancers thank you So much, I kept the formula that you mentioned as it is cause modifying it by "0" instead of "blank" makes the App brings only one txt file no matter how many txt files in the Dropbox folder , but on the other hand i modified the code to be : If LiceRow >= 0 then LicRow = .Range("A99999").End(xlUp).Row + 1 and it perfectly worked. thank you so much and sry for bothering you with many questions.
@ExcelForFreelancers
@ExcelForFreelancers Жыл бұрын
Great, I am glad you got it to work., thanks so much. this is what i do for most newer videos (this is from another application but the process is always the same) If .Range("B4").Value = Empty Then 'New order OrderRow = Orders.Range("A99999").End(xlUp).Row + 1 'First Avail. Row Orders.Range("A" & OrderRow).Value = .Range("B3").Value 'Order ID Else 'Existing order OrderRow = .Range("B4").Value 'Existing Order row End If So i assign the variable AFTER I determine it is blank Please follow this process moving forward on any new application. I hope this helps and thanks so much.
@forex7769
@forex7769 2 жыл бұрын
Very brilliant omgoodness But what if I update the wb can the registered user still access that when I upload it and will the same licence key work 🙂 👍 u r da man.
@ExcelForFreelancers
@ExcelForFreelancers 2 жыл бұрын
Hi and thanks for your comment. Each time a workbook opens you can run a check to see if this workbook has been registered. You can also tie a specific workbook to a specific machine if you like. I show you how to do this in my Mentorship course here: www.excelforfreelancers.com/product/excel-for-freelancers-mentorship-program/
@forex7769
@forex7769 2 жыл бұрын
How much is that course I'm not sure which one it is, but licensing excel to a machine would be best I think. Can people still access modify vba and cells if they want. Is it pain free for user to download update wb and still be only registered to that machine hassle free. People get annoyed if they have to do to much as I'm sure you know. Thanks 👍🙂👍
@tier1athlete829
@tier1athlete829 2 жыл бұрын
How can we protect the excel workbook we selling to not be shared by the end user to have another person download the excel workbook on a different computer
@JonathanKDeau
@JonathanKDeau 2 жыл бұрын
That is my question as well. Would love to hear from Randy on this one.
@JonathanKDeau
@JonathanKDeau 2 жыл бұрын
Just found this older video that may help a little. kzfaq.info/get/bejne/ZseYjNKqmrKXlZc.html
@ExcelForFreelancers
@ExcelForFreelancers 2 жыл бұрын
Hi and thanks so much. I cover that completely in my Mentorship course here: www.excelforfreelancers.com/product/excel-for-freelancers-mentorship-program/ Thank you for your Likes, Shares & Comments. It really helps.
@slminc
@slminc 2 жыл бұрын
Locking the application to a specific machine is the best thing that has ever happened in excel. The Mentorship Program covers all that.
@ChristiaanRoest79
@ChristiaanRoest79 6 ай бұрын
Does it also cover copying the code to a workbook you want to license and link it to the license manager? I bought the mentorship course and it only seem to cover the licensemanager with added code to this workbook. ​@@slminc
@kamalraj2050
@kamalraj2050 2 жыл бұрын
Amazing advice
@ExcelForFreelancers
@ExcelForFreelancers 2 жыл бұрын
Thank you so very much, I really appreciate that Kamal
@Dray7211
@Dray7211 Жыл бұрын
I love this process but everytime I try to use it to learn more, it states not connected to the internet. I am not sure what I am doing wrong or what I missed in the code to change this. A little help would be appreciated. Thanks.
@ExcelForFreelancers
@ExcelForFreelancers Жыл бұрын
Hi Dray, Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.
@cxhafij7295
@cxhafij7295 2 жыл бұрын
Excellent video
@ExcelForFreelancers
@ExcelForFreelancers 2 жыл бұрын
Thank you so very much, I really appreciate that :)
@MdAlamin-ej9st
@MdAlamin-ej9st 2 жыл бұрын
Good video
@ExcelForFreelancers
@ExcelForFreelancers 2 жыл бұрын
Thanks for the visit and much appreciated Alamin
@rafsanahamedridoy2853
@rafsanahamedridoy2853 2 жыл бұрын
Thanks for a lot
@ExcelForFreelancers
@ExcelForFreelancers 2 жыл бұрын
For sure, you are very welcome and happy to help and share.
@Rockybaikalov
@Rockybaikalov Жыл бұрын
Easy. I would crack into the VBA code, make change to it, and use the work book without expiry
@ExcelForFreelancers
@ExcelForFreelancers Жыл бұрын
For sure it can be done, but that should never stop you from developing and selling these applications. I much rather 1 person crack my code and get it for free and the other 99 pay for it, then not selling to anyone. Thank you for your Likes, Shares & Comments. It really helps.
@slminc
@slminc Жыл бұрын
I really don’t understand what is the obsession about cracking software. Some of the people who like to crack software they don’t realise that we really want them to do that so that they can get satisfaction. After cracking then what?
@sathibacher1027
@sathibacher1027 2 жыл бұрын
Nice video
@ExcelForFreelancers
@ExcelForFreelancers 2 жыл бұрын
Thank you very much. So nice of you Sathi
@RussCrowley
@RussCrowley Жыл бұрын
Superb, Randy. Right, how do I do this with Microsoft Word? :D
@ExcelForFreelancers
@ExcelForFreelancers Жыл бұрын
Hi and thanks so much. I have not tried this with Word, just excel. Thank you for your Likes, Shares & Comments. It really helps.
@elmadawygames6677
@elmadawygames6677 6 ай бұрын
can you send it here because i can't find it here, so i wish you send the json file here it will be very help ful for me if you did, thank you randy
@ExcelForFreelancers
@ExcelForFreelancers 6 ай бұрын
Hi and thanks very much. The only download I have available is the workbook download using the link in the description. I hope this helps and thanks so much.
@siyamgamer5511
@siyamgamer5511 2 жыл бұрын
Nice vidoe
@ExcelForFreelancers
@ExcelForFreelancers 2 жыл бұрын
Thank you so very much, I really appreciate that
@asifkazi1907
@asifkazi1907 2 жыл бұрын
Amazing video
@ExcelForFreelancers
@ExcelForFreelancers 2 жыл бұрын
Glad you think so and Thanks so much. Very kind of you Asif
@jnsound2962
@jnsound2962 2 жыл бұрын
খুব সুন্দর একটা ভিডিও
@ExcelForFreelancers
@ExcelForFreelancers 2 жыл бұрын
Thank you so very much, I really appreciate that J N
@md.asmatali1461
@md.asmatali1461 2 жыл бұрын
Very nice amazing advice app
@ExcelForFreelancers
@ExcelForFreelancers 2 жыл бұрын
Thank you for your Likes, Shares & Comments. It really helps.
@ilhomeshimov3964
@ilhomeshimov3964 2 жыл бұрын
awesome, tnx lady :>
@ExcelForFreelancers
@ExcelForFreelancers 2 жыл бұрын
You are very welcome and I am happy to help Ilhom
@osheshadimaosheshadima7610
@osheshadimaosheshadima7610 2 жыл бұрын
Good
@ExcelForFreelancers
@ExcelForFreelancers 2 жыл бұрын
Thank you so very much, I really appreciate that
@Jesterthe
@Jesterthe 2 жыл бұрын
Data not sent to remote database. Please check for internet connection & correct webhook setup This Message appears when i try to save
@ExcelForFreelancers
@ExcelForFreelancers 2 жыл бұрын
Hi and thanks that means your webhook is not set up correctly. Please re-watch the training video again, since i go over the causes of this in the video. I hope this helps and thanks so much.
@nirunirupoma1376
@nirunirupoma1376 2 жыл бұрын
Nice
@ExcelForFreelancers
@ExcelForFreelancers 2 жыл бұрын
Thanks so much Niru :) Thank you for your Likes, Shares & Comments. It really helps.
@StephanBussing
@StephanBussing Жыл бұрын
Nice video, just wondering where/how to download this workbook. Cannot find a link.
@StephanBussing
@StephanBussing Жыл бұрын
Never mind, due to automatic translation, the link to request the WB was gone.
@ExcelForFreelancers
@ExcelForFreelancers Жыл бұрын
Hi Stephen, I will check on this. Thanks and I am glad you got the workbook.
@noambrand
@noambrand Жыл бұрын
I wonder about an existing user that I want to extend his expiration date directly through editing in a database in Make, but the "PATCH" method does not allow that because it reads data from the workbook and updates the database. I tried using the "GET" method but it didn't work.
@ExcelForFreelancers
@ExcelForFreelancers Жыл бұрын
Hi @Noambrand. Thanks for your comment. You should be able to use the workbook to GET a specific date via a webhook, when you push a user ID or application ID and then update the local user. I am working on a solution that does not involve Make and allows you to sell licensed products or addins and I will put that into a mini-course in the coming months. I hope this helps and thanks so much.
@noambrand
@noambrand Жыл бұрын
@@ExcelForFreelancers I got it to work, with Make I calculated 1MB is enough for about 1500 lines before having to pay 9$ a month for extra storage.
@ExcelForFreelancers
@ExcelForFreelancers Жыл бұрын
Ok perfect, that sounds great. Thanks for sharing Noambrand
@noambrand
@noambrand Жыл бұрын
​@@ExcelForFreelancers I would love to hear more about the solution that does not involve Make and mini-course.
@ExcelForFreelancers
@ExcelForFreelancers Жыл бұрын
@Noambrand I have been working with a new plugin lately called "License Manager for WooCommerce (Free)" they have a simple, but great API that allows you to both read and write directly to the license data, so you could easily read the expiration date and write to the expiration date using a webhook, without needed to use Make (which i really like, because i would rather not use Make) You can check out their API Documentation here: www.licensemanager.at/documentation/rest-api/developer-documentation/retrieve-a-license/ I am thinking to create a course on this licensing system.
@asarohi4845
@asarohi4845 2 жыл бұрын
Good job
@ExcelForFreelancers
@ExcelForFreelancers 2 жыл бұрын
Thank you for your Likes, Shares & Comments. It really helps.
@eliastafese3790
@eliastafese3790 2 жыл бұрын
I think i have problem when i sending information to the webhooks how can i fix this? HELP ME PLS.
@ExcelForFreelancers
@ExcelForFreelancers 2 жыл бұрын
Hi and thanks make sure to watch the video, use a new webhook that you create and make sure your scenario is turned on. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
@reliableservices5383
@reliableservices5383 2 жыл бұрын
Randy sir if anybody knows how to open a VBA editor password or sheet protect password then how can we prevent this problem, Please suggest.
@ExcelForFreelancers
@ExcelForFreelancers 2 жыл бұрын
Hi and thanks you can try searching Google for some solutions.
@VivoY-cg2wl
@VivoY-cg2wl 2 жыл бұрын
good vido
@ExcelForFreelancers
@ExcelForFreelancers 2 жыл бұрын
Thank you so much. Very kind of you
@mdkaium4281
@mdkaium4281 2 жыл бұрын
Amazing nice video 😍😘💓😍
@ExcelForFreelancers
@ExcelForFreelancers 2 жыл бұрын
I'm glad you like it. Thank you very much Kaium
@sasikumar-tn9eq
@sasikumar-tn9eq Жыл бұрын
Hello Randy, it's very good program, kindly share the source files
@ExcelForFreelancers
@ExcelForFreelancers Жыл бұрын
Hi and thanks so much, you can download this file using the links in the description under the word DOWNLOAD. I hope this helps and thanks.
@mdsoibe6282
@mdsoibe6282 2 жыл бұрын
So Nice video
@ExcelForFreelancers
@ExcelForFreelancers 2 жыл бұрын
Many many thanks Soibe
@ruhanarimi4430
@ruhanarimi4430 2 жыл бұрын
Nice video ❤️❤️
@ExcelForFreelancers
@ExcelForFreelancers 2 жыл бұрын
Thank you so very much, I really appreciate that Rimi
@malakhatun3802
@malakhatun3802 2 жыл бұрын
Nice video good video
@ExcelForFreelancers
@ExcelForFreelancers 2 жыл бұрын
Thank you so very much, I really appreciate that Khatun
@mabutingBata
@mabutingBata Жыл бұрын
thanks for the tut., the software manager is not integrated to the user app., can i have your template please..thanks
@ExcelForFreelancers
@ExcelForFreelancers Жыл бұрын
Hi, you can download this file using the links in the description under the word DOWNLOAD. I hope this helps and thanks.
@mabutingBata
@mabutingBata Жыл бұрын
ive downloaded many times sir but the result is still same, i followed your steps on making a scenario, if new account created on users it integrate it, but in software manager is not..please help me through this, i really need this app. ☺️thanks and more power...
@ExcelForFreelancers
@ExcelForFreelancers Жыл бұрын
Hi and thanks, this software manager template is designed to work with any software you want, however it does require intermediate to advanced VBA knowledge. I am not sure what you mean by "user app", since in this video I am only teaching you how to create a license with your software. If you need specific help with this, i can suggest you create a PAID JOB post in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.
@mabutingBata
@mabutingBata Жыл бұрын
thanks sir., i will post my queries there, thank you and God bless.
@ChristiaanRoest79
@ChristiaanRoest79 7 ай бұрын
Where can i find this licensing software?
@ExcelForFreelancers
@ExcelForFreelancers 7 ай бұрын
Hi, you can download this file using the links in the description under the word DOWNLOAD. I hope this helps and thanks.
@francescasole6857
@francescasole6857 Жыл бұрын
it says I dont have the correct webhook? please can someone help
@ExcelForFreelancers
@ExcelForFreelancers Жыл бұрын
Hi and thanks, please make sure to watch the entire training video to learn about webhooks. I hope this helps and thanks so much.
@md.robiulislam1734
@md.robiulislam1734 2 жыл бұрын
Soo nice
@ExcelForFreelancers
@ExcelForFreelancers 2 жыл бұрын
Thank you so very much, I really appreciate that.
@mdsohelrana4186
@mdsohelrana4186 2 жыл бұрын
wonderful l vedio
@ExcelForFreelancers
@ExcelForFreelancers 2 жыл бұрын
Thanks for watching Rana. Much appreciated.
@shakilahmed-xc5fp
@shakilahmed-xc5fp 2 жыл бұрын
OMG TNX :D :D :D
@ExcelForFreelancers
@ExcelForFreelancers 2 жыл бұрын
Thank you so very much, I really appreciate that
@mdborhankhan3559
@mdborhankhan3559 2 жыл бұрын
Amazing
@ExcelForFreelancers
@ExcelForFreelancers 2 жыл бұрын
Thank you so very much, I really appreciate that Borhan
@slminc
@slminc 11 ай бұрын
Maybe I must sell my customised version to freelancers. What do you think? It contains an additional workbook you created here on KZfaq
@ExcelForFreelancers
@ExcelForFreelancers 11 ай бұрын
I think its a fantastic idea. You should hurry up before lots of people do this :)
@slminc
@slminc 11 ай бұрын
Consider it done!
Learn Excel MACROS in 10 Minutes Using Real World Examples
9:13
Kenji Explains
Рет қаралды 1,1 МЛН
Landmark ruling: how Google broke the law | About That
13:49
CBC News
Рет қаралды 152 М.
SCHOOLBOY. Последняя часть🤓
00:15
⚡️КАН АНДРЕЙ⚡️
Рет қаралды 9 МЛН
Smart Sigma Kid #funny #sigma #comedy
00:40
CRAZY GREAPA
Рет қаралды 36 МЛН
Kamala Harris, explained in 7 moments
13:04
Vox
Рет қаралды 1,6 МЛН
Power BI vs Excel Dashboards - And the winner is...
11:55
MyOnlineTrainingHub
Рет қаралды 273 М.
What do tech pioneers think about the AI revolution? - BBC World Service
25:48
The 14 Must-Know String Manipulation Functions In VBA
18:51
Excel For Freelancers
Рет қаралды 3,9 М.
Quick License Manager - Protect an Excel app
8:16
Soraco Technologies
Рет қаралды 7 М.
Unlock Excel Secrets: Magic Search Bar You NEVER Knew About!
17:59
PK: An Excel Expert
Рет қаралды 502 М.
These Websites Generate Online Courses in Minutes!
13:10
Aurelius Tjin
Рет қаралды 158 М.