Hey there! Love your videos, they’ve been super helpful. I’m working on a project management app and hitting a snag with loading and saving data across multiple database sheets. For instance, I’ve got a projects sheet and a tasks sheet. The tasks use a ProjectID (like 1 for the project, then 101 for the first task, 102 for the second, and so on). I need to load the main project and its associated tasks all at once. Could you make a video on this or give me some pointers? Thanks!
Hi and thanks very much. I do have a series of videos on this with both Projects and Tasks here: ruclips.net/p/PLIBeRriXvKzBgiKcu6UdD9E_4S8xiKUWq I hope this helps and thanks so much.
Dear Randy thank you on yours teachings. Can you advise me on this one, in our company we have a server and there is a lot of folders and subfolders on server. My chief told me one day that he wants to see who has permission on which folders and subfolders. He means who from employees has rights to read, edit, copy etc… Can it be done via VBA? Thank you in advance.
HI and thanks for your comment. Yes I believe it is possible using the shell command and icacls however I have not tried any specific code to do this. It would take a bit of research. I hope this helps and thanks so much.
Hi and thanks. The long black like in the VBA editor is automated after every Sub routine. I hope this helps and thanks so much. Thank you for your Likes, Shares & Comments. It really helps.
Thanks, could u plz do videos about converting xlsm to exe with rights restrictions and without relying on Excel when saving or editing data. Thanks again
Hi and thanks so much. While you can convert Excel to exe, when extracting the core file, you will always require Excel to make it function. I hope this helps and thanks so much.
Hi and thanks for your comment. I am not sure which workbook you are referring to. Can you share the video link here in the comments so I can check it out? Thanks very much
@@ExcelForFreelancers it's this video (Codez VBA comme un pro avec ces meilleures pratiques), the exercices book in the download site is for : the pharmacy pos
Hi and thanks for letting me know. I did check the link and i see the email is incorrect. I will fix that right away. However, you can download the 5 Best Practices Workbook from the following link: www.dropbox.com/scl/fi/3k94zfc4yppgtmr33mjlr/VBA_Best_Practices.xlsm?rlkey=xyd5krk7pqq464qrsnc62au7x&dl=1
😱 𝗧𝗨𝗥𝗡 𝗖𝗢𝗠𝗣𝗟𝗘𝗫 𝗗𝗔𝗧𝗔 𝗜𝗡𝗧𝗢 𝗦𝗜𝗠𝗣𝗟𝗘 𝗦𝗢𝗟𝗨𝗧𝗜𝗢𝗡𝗦 𝗪𝗜𝗧𝗛 𝗔𝗜 ▶ www.excelforfreelancers.com/AiDataAnalystYTPinnedComment
Nice Randy. More shortcuts and training!
For sure, you are very welcome Joe, thanks again
Can you make video that cover class module intermediate skills.
HI and thanks so much. I have a basic Class Module training here: ruclips.net/video/8j8BvTAPNX4/видео.html
I hope this helps and thanks so much.
⚡ 𝗦𝗜𝗠𝗣𝗟𝗜𝗙𝗬 𝗖𝗢𝗠𝗣𝗟𝗘𝗫 𝗘𝗫𝗖𝗘𝗟 𝗧𝗔𝗦𝗞𝗦 𝗜𝗡𝗦𝗧𝗔𝗡𝗧𝗟𝗬 𝗪𝗜𝗧𝗛 𝗘𝗫𝗖𝗘𝗟 𝗔𝗜 𝗧𝗢𝗢𝗟𝗣𝗔𝗖𝗞 𝗔𝗗𝗗-𝗜𝗡 👉 www.excelforfreelancers.com/ai-toolpack
Thanks for the share Randy.
For sure, you are very welcome Syed. thanks so much for your continued support
Hey there! Love your videos, they’ve been super helpful. I’m working on a project management app and hitting a snag with loading and saving data across multiple database sheets. For instance, I’ve got a projects sheet and a tasks sheet. The tasks use a ProjectID (like 1 for the project, then 101 for the first task, 102 for the second, and so on). I need to load the main project and its associated tasks all at once. Could you make a video on this or give me some pointers? Thanks!
Hi and thanks very much. I do have a series of videos on this with both Projects and Tasks here: ruclips.net/p/PLIBeRriXvKzBgiKcu6UdD9E_4S8xiKUWq
I hope this helps and thanks so much.
Dear Randy thank you on yours teachings.
Can you advise me on this one, in our company we have a server and there is a lot of folders and subfolders on server.
My chief told me one day that he wants to see who has permission on which folders and subfolders.
He means who from employees has rights to read, edit, copy etc…
Can it be done via VBA?
Thank you in advance.
HI and thanks for your comment. Yes I believe it is possible using the shell command and icacls however I have not tried any specific code to do this. It would take a bit of research. I hope this helps and thanks so much.
How did u put the long black line?
Hi and thanks. The long black like in the VBA editor is automated after every Sub routine. I hope this helps and thanks so much. Thank you for your Likes, Shares & Comments. It really helps.
Thanks, could u plz do videos about converting xlsm to exe with rights restrictions and without relying on Excel when saving or editing data. Thanks again
Hi and thanks so much. While you can convert Excel to exe, when extracting the core file, you will always require Excel to make it function. I hope this helps and thanks so much.
@@ExcelForFreelancers thanks a lot
THNX Randy
For sure, you are very welcome Henk. I am happy to help and share
thanks !
For sure, you are very welcome and happy to help and share
hellow, "THE EXERCISE BOOK TEMPLATE" doesnt match, thank you for a replacement
Hi and thanks for your comment. I am not sure which workbook you are referring to. Can you share the video link here in the comments so I can check it out? Thanks very much
@@ExcelForFreelancers it's this video (Codez VBA comme un pro avec ces meilleures pratiques), the exercices book in the download site is for : the pharmacy pos
i want the exercises book for : 5 Best practices in vba, in the video link it refers to the Pharmacy POS. Thank you
Hi and thanks for letting me know. I did check the link and i see the email is incorrect. I will fix that right away. However, you can download the 5 Best Practices Workbook from the following link:
www.dropbox.com/scl/fi/3k94zfc4yppgtmr33mjlr/VBA_Best_Practices.xlsm?rlkey=xyd5krk7pqq464qrsnc62au7x&dl=1
@@ExcelForFreelancers Thanks a lot