🔥Download 350 Of The Worlds Best Templates Here ► rebrand.ly/350Wkbks_YTPinnedCom
@alanpowell242 жыл бұрын
Randy works so hard and is so disciplined with his output. He deserves to succeed !
@ExcelForFreelancers2 жыл бұрын
Thanks so very much Alan. I do appreciate that :) :)
@joemanflyer200122 күн бұрын
This would help all those independent software developers like you !
@ExcelForFreelancers21 күн бұрын
Absolutely. Thanks so much Joe
@craigmorrison65262 жыл бұрын
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 ....
@ExcelForFreelancers2 жыл бұрын
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.
@craigmorrison65262 жыл бұрын
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_Official2 жыл бұрын
I like the company . Believe in Your success this year. Carefully following Your development, I joined the project and will strongly support this project.
@ExcelForFreelancers2 жыл бұрын
Thank you so very much, I really appreciate that Asif
@floeru12Ай бұрын
Amazing Video! Thank you so much!
@ExcelForFreelancersАй бұрын
Thank you so very much, I really appreciate that
@slminc Жыл бұрын
I combined this application with the one-click update - what a breeze. One centralised workbook for all my freelance jobs.
@ExcelForFreelancers Жыл бұрын
Oh that is really smart. The combination will work very well
@slminc Жыл бұрын
The logical approach is key in development of VBA Applications
@ExcelForFreelancers Жыл бұрын
Absolutely. Thanks so much Sammy
@ianhenderson19742 жыл бұрын
Fantastic tutorial. Now I need to learn the integromat portion. Thank you Randy
@ExcelForFreelancers2 жыл бұрын
Glad it was helpful and thanks so much Ian. Thank you for your Likes, Shares & Comments. It really helps.
@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 Жыл бұрын
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.
@mokterail1232 жыл бұрын
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
@ExcelForFreelancers2 жыл бұрын
Thanks so much. Very kind of you Mokter
@bestscenes14692 жыл бұрын
Such an amazing guru. I can't wait for it.
@ExcelForFreelancers2 жыл бұрын
Thank you so very much, I really appreciate that. I am sure you will love this one.
@redtee9463 ай бұрын
I can't thank you enough !!!!
@ExcelForFreelancers3 ай бұрын
For sure, you are very welcome. I am happy to help and share
@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 Жыл бұрын
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.
@veerapandij25362 жыл бұрын
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 👍…
@ExcelForFreelancers2 жыл бұрын
Thank you so very much, I really appreciate that. :)
@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 Жыл бұрын
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.
@vishalgohil9312 жыл бұрын
Fantastic. Thank you very much for this trick. Nobody else was able to explain this.
@ExcelForFreelancers2 жыл бұрын
For sure, you are very welcome Vishal
@haroldluciano52032 жыл бұрын
Thanks Randy for the nice tutorial...live watching now.
@ExcelForFreelancers2 жыл бұрын
For sure, you are very welcome. Thank you for your Likes, Shares & Comments. It really helps.
@saqlainshaikh99362 жыл бұрын
Randy Sir you are amazing thanks a lot
@ExcelForFreelancers2 жыл бұрын
Thank you so very much, I really appreciate that Shaikh
@H-do8tr2 жыл бұрын
GREAT as usual! 😍 How can I use this software with XLS PadLock?
@ExcelForFreelancers2 жыл бұрын
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.
@jonnoedge1672 жыл бұрын
Can't wait for this, this channel is the best for Excel & VBA. Legends!!
@ExcelForFreelancers2 жыл бұрын
Thank you so very much, I really appreciate that Jonno
@Dalimscreative2 жыл бұрын
Fantastic tutorial
@ExcelForFreelancers2 жыл бұрын
Thanks so much. Very kind of you. Thank you for your Likes, Shares & Comments. It really helps.
@t-seriesapp49672 жыл бұрын
Interesting tutorial. I can't wait to have it.
@ExcelForFreelancers2 жыл бұрын
Thanks so much George. I know you will really enjoy it.
@catherinesecreto89562 жыл бұрын
This is great Randy! Can't wait for it! 💚
@ExcelForFreelancers2 жыл бұрын
thank you so very much Catherine :)
@khuranav66 ай бұрын
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.
@ExcelForFreelancers6 ай бұрын
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.
@tier1athlete8292 жыл бұрын
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.
@ExcelForFreelancers2 жыл бұрын
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 Жыл бұрын
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 Жыл бұрын
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.
@nazirulislam24912 жыл бұрын
This is very helpful video. Thanks for sharing the video.
@ExcelForFreelancers2 жыл бұрын
For sure, you are very welcome. Thank you for your Likes, Shares & Comments. It really helps.
@VS-rh8rq2 жыл бұрын
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
@ExcelForFreelancers2 жыл бұрын
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 Жыл бұрын
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 Жыл бұрын
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.
@PatrickAngwin7 ай бұрын
Hi, this looks great! Just one question: could this be used to license add-ins or just entire workbooks? Many thanks.
@ExcelForFreelancers7 ай бұрын
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 Жыл бұрын
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 Жыл бұрын
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.
@alaminhossen15182 жыл бұрын
This is absolutely beautiful advice
@ExcelForFreelancers2 жыл бұрын
Thank you very much. So nice of you Shimu
@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 Жыл бұрын
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.
@Phemelocutie2 жыл бұрын
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
@ExcelForFreelancers2 жыл бұрын
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.
@bashirdhali93722 жыл бұрын
Good and absolutely amazing advice
@ExcelForFreelancers2 жыл бұрын
Thank you very much, I really appreciate that Bashir.
@samahnation2 жыл бұрын
Halo Randy! Does the applications connected to licensing needs internet every time the user needs to use them?
@ExcelForFreelancers2 жыл бұрын
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.
@raselparvez95322 жыл бұрын
Thanks sir for your good explanation
@ExcelForFreelancers2 жыл бұрын
For sure, you are very welcome Rasel
@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 Жыл бұрын
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 Жыл бұрын
@@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 Жыл бұрын
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 Жыл бұрын
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 Жыл бұрын
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.
@ChristiaanRoest797 ай бұрын
The problem is that these passwords can be easily removed with tools@@ExcelForFreelancers
@MahabubAlam-ek8be2 жыл бұрын
This is absolutely amazing advice
@ExcelForFreelancers2 жыл бұрын
Thank you so very much, I really appreciate that Mahabub
@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 Жыл бұрын
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 Жыл бұрын
@@ExcelForFreelancers Thanks again for your feedback my Mentor. I much appreciate you a lot. Bless you.
@ExcelForFreelancers Жыл бұрын
Its no problem, I am happy to help and share Richard
@SyedMuzammilMahasanShahi2 жыл бұрын
Thank you Randy for this amazing video.
@ExcelForFreelancers2 жыл бұрын
For sure, you are very welcome and thanks for your continued support.
@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 Жыл бұрын
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 Жыл бұрын
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 Жыл бұрын
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 Жыл бұрын
@@ExcelForFreelancers thanks for the replay how is this is set up on the video /download version
@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.
@josemiguelbaztan96076 ай бұрын
Thank you Randy. Is there a way to generate the registration process after payment received automatically?
@ExcelForFreelancers6 ай бұрын
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.
@mdriajul86692 жыл бұрын
Absolutely amazing advice 🥰🥰
@ExcelForFreelancers2 жыл бұрын
Glad you think so and thanks so much
@lmt1252 жыл бұрын
Ohh wow this will help scale and protect ⬆️⬆️⬆️
@ExcelForFreelancers2 жыл бұрын
Yes now doubt. I am happy to share and help. Thanks again.
@ramishamali2745 Жыл бұрын
Amazing one Randy... instead of drop box, what option should i pick to use MSFT One Drive?
@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 Жыл бұрын
@@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 Жыл бұрын
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.
@RichardNickyBrian2 ай бұрын
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.
@ExcelForFreelancers2 ай бұрын
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.
@RichardNickyBrian2 ай бұрын
@@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.
@ExcelForFreelancers2 ай бұрын
For sure, you are very welcome and I am happy to help and share.
@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 Жыл бұрын
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 Жыл бұрын
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 Жыл бұрын
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.
@chumkiisrat30652 жыл бұрын
Absolutely amazing
@ExcelForFreelancers2 жыл бұрын
Thanks so much. Very kind of you Chumki
@guelaboy22332 жыл бұрын
Wooow thankx Lord, i can't wait to have it💻
@ExcelForFreelancers2 жыл бұрын
For sure, you are very welcome Guela. Thank you for your Likes, Shares & Comments. It really helps.
@elmadawygames66776 ай бұрын
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
@ExcelForFreelancers6 ай бұрын
Hi, you can download this file using the links in the description under the word DOWNLOAD. I hope this helps and thanks.
@elmadawygames66776 ай бұрын
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
@ExcelForFreelancers6 ай бұрын
Hi and thanks very much. I only have the download workbook available and nothing else. I hope this helps and thanks so much.
@sorolvision79862 жыл бұрын
Nice video good video.
@ExcelForFreelancers2 жыл бұрын
Thank you so very much, I really appreciate that Sorol
@tier1athlete8292 жыл бұрын
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?
@ExcelForFreelancers2 жыл бұрын
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.
@gordenhildebrand81842 жыл бұрын
Thanks I wanna get into electronic soft.
@ExcelForFreelancers2 жыл бұрын
Thanks so much. Very kind of you Gorden
@kunalchangoiwala74742 жыл бұрын
If you could kindly guide on how to use such licensing system to share and protect pdf, mp4, other file formats..
@ExcelForFreelancers2 жыл бұрын
Hi and thanks so much. I am focused on Excel training only for this time. I hope this helps and thanks so much.
@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 Жыл бұрын
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_199x82 жыл бұрын
Thankyou for the tutorial :))
@ExcelForFreelancers2 жыл бұрын
For sure, you are very welcome Jessy
@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 Жыл бұрын
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 Жыл бұрын
@@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 Жыл бұрын
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 Жыл бұрын
@@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 Жыл бұрын
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.
@forex77692 жыл бұрын
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.
@ExcelForFreelancers2 жыл бұрын
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/
@forex77692 жыл бұрын
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 👍🙂👍
@tier1athlete8292 жыл бұрын
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
@JonathanKDeau2 жыл бұрын
That is my question as well. Would love to hear from Randy on this one.
@JonathanKDeau2 жыл бұрын
Just found this older video that may help a little. kzfaq.info/get/bejne/ZseYjNKqmrKXlZc.html
@ExcelForFreelancers2 жыл бұрын
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.
@slminc2 жыл бұрын
Locking the application to a specific machine is the best thing that has ever happened in excel. The Mentorship Program covers all that.
@ChristiaanRoest796 ай бұрын
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
@kamalraj20502 жыл бұрын
Amazing advice
@ExcelForFreelancers2 жыл бұрын
Thank you so very much, I really appreciate that Kamal
@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 Жыл бұрын
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.
@cxhafij72952 жыл бұрын
Excellent video
@ExcelForFreelancers2 жыл бұрын
Thank you so very much, I really appreciate that :)
@MdAlamin-ej9st2 жыл бұрын
Good video
@ExcelForFreelancers2 жыл бұрын
Thanks for the visit and much appreciated Alamin
@rafsanahamedridoy28532 жыл бұрын
Thanks for a lot
@ExcelForFreelancers2 жыл бұрын
For sure, you are very welcome and happy to help and share.
@Rockybaikalov Жыл бұрын
Easy. I would crack into the VBA code, make change to it, and use the work book without expiry
@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 Жыл бұрын
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?
@sathibacher10272 жыл бұрын
Nice video
@ExcelForFreelancers2 жыл бұрын
Thank you very much. So nice of you Sathi
@RussCrowley Жыл бұрын
Superb, Randy. Right, how do I do this with Microsoft Word? :D
@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.
@elmadawygames66776 ай бұрын
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
@ExcelForFreelancers6 ай бұрын
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.
@siyamgamer55112 жыл бұрын
Nice vidoe
@ExcelForFreelancers2 жыл бұрын
Thank you so very much, I really appreciate that
@asifkazi19072 жыл бұрын
Amazing video
@ExcelForFreelancers2 жыл бұрын
Glad you think so and Thanks so much. Very kind of you Asif
@jnsound29622 жыл бұрын
খুব সুন্দর একটা ভিডিও
@ExcelForFreelancers2 жыл бұрын
Thank you so very much, I really appreciate that J N
@md.asmatali14612 жыл бұрын
Very nice amazing advice app
@ExcelForFreelancers2 жыл бұрын
Thank you for your Likes, Shares & Comments. It really helps.
@ilhomeshimov39642 жыл бұрын
awesome, tnx lady :>
@ExcelForFreelancers2 жыл бұрын
You are very welcome and I am happy to help Ilhom
@osheshadimaosheshadima76102 жыл бұрын
Good
@ExcelForFreelancers2 жыл бұрын
Thank you so very much, I really appreciate that
@Jesterthe2 жыл бұрын
Data not sent to remote database. Please check for internet connection & correct webhook setup This Message appears when i try to save
@ExcelForFreelancers2 жыл бұрын
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.
@nirunirupoma13762 жыл бұрын
Nice
@ExcelForFreelancers2 жыл бұрын
Thanks so much Niru :) Thank you for your Likes, Shares & Comments. It really helps.
@StephanBussing Жыл бұрын
Nice video, just wondering where/how to download this workbook. Cannot find a link.
@StephanBussing Жыл бұрын
Never mind, due to automatic translation, the link to request the WB was gone.
@ExcelForFreelancers Жыл бұрын
Hi Stephen, I will check on this. Thanks and I am glad you got the workbook.
@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 Жыл бұрын
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 Жыл бұрын
@@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 Жыл бұрын
Ok perfect, that sounds great. Thanks for sharing Noambrand
@noambrand Жыл бұрын
@@ExcelForFreelancers I would love to hear more about the solution that does not involve Make and mini-course.
@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.
@asarohi48452 жыл бұрын
Good job
@ExcelForFreelancers2 жыл бұрын
Thank you for your Likes, Shares & Comments. It really helps.
@eliastafese37902 жыл бұрын
I think i have problem when i sending information to the webhooks how can i fix this? HELP ME PLS.
@ExcelForFreelancers2 жыл бұрын
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
@reliableservices53832 жыл бұрын
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.
@ExcelForFreelancers2 жыл бұрын
Hi and thanks you can try searching Google for some solutions.
@VivoY-cg2wl2 жыл бұрын
good vido
@ExcelForFreelancers2 жыл бұрын
Thank you so much. Very kind of you
@mdkaium42812 жыл бұрын
Amazing nice video 😍😘💓😍
@ExcelForFreelancers2 жыл бұрын
I'm glad you like it. Thank you very much Kaium
@sasikumar-tn9eq Жыл бұрын
Hello Randy, it's very good program, kindly share the source files
@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.
@mdsoibe62822 жыл бұрын
So Nice video
@ExcelForFreelancers2 жыл бұрын
Many many thanks Soibe
@ruhanarimi44302 жыл бұрын
Nice video ❤️❤️
@ExcelForFreelancers2 жыл бұрын
Thank you so very much, I really appreciate that Rimi
@malakhatun38022 жыл бұрын
Nice video good video
@ExcelForFreelancers2 жыл бұрын
Thank you so very much, I really appreciate that Khatun
@mabutingBata Жыл бұрын
thanks for the tut., the software manager is not integrated to the user app., can i have your template please..thanks
@ExcelForFreelancers Жыл бұрын
Hi, you can download this file using the links in the description under the word DOWNLOAD. I hope this helps and thanks.
@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 Жыл бұрын
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 Жыл бұрын
thanks sir., i will post my queries there, thank you and God bless.
@ChristiaanRoest797 ай бұрын
Where can i find this licensing software?
@ExcelForFreelancers7 ай бұрын
Hi, you can download this file using the links in the description under the word DOWNLOAD. I hope this helps and thanks.
@francescasole6857 Жыл бұрын
it says I dont have the correct webhook? please can someone help
@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.robiulislam17342 жыл бұрын
Soo nice
@ExcelForFreelancers2 жыл бұрын
Thank you so very much, I really appreciate that.
@mdsohelrana41862 жыл бұрын
wonderful l vedio
@ExcelForFreelancers2 жыл бұрын
Thanks for watching Rana. Much appreciated.
@shakilahmed-xc5fp2 жыл бұрын
OMG TNX :D :D :D
@ExcelForFreelancers2 жыл бұрын
Thank you so very much, I really appreciate that
@mdborhankhan35592 жыл бұрын
Amazing
@ExcelForFreelancers2 жыл бұрын
Thank you so very much, I really appreciate that Borhan
@slminc11 ай бұрын
Maybe I must sell my customised version to freelancers. What do you think? It contains an additional workbook you created here on KZfaq
@ExcelForFreelancers11 ай бұрын
I think its a fantastic idea. You should hurry up before lots of people do this :)