How To Manipulate Files & Folders With Excel VBA For Beginners

Рет қаралды 5,709

Excel For Freelancers

Күн бұрын

Пікірлер: 53

@ExcelForFreelancers 2 ай бұрын

🔥Download 350 Of The Worlds Best Templates Here ► rebrand.ly/350Wkbks_YTPinnedCom

@ahmedamer-kozika 28 күн бұрын

Greetings from Egypt. My implementation of your "Art" after over 100hrs of studying and repeating your "Art" videos throughout your "Art channel" got me a dream job remotely, so you deserves a golden like and a prober thanks comment at least .

@ExcelForFreelancers 27 күн бұрын

Great to hear that. Thanks so much and I am really happy to help and share

@markhuang368 Ай бұрын

Hi Randy. Thanks for the excellent video. Could you please consider making another video showing how to manipulate files and folders that are stored in Microsoft sharepoint locations via VBA? Thanks.

@ExcelForFreelancers Ай бұрын

Hi and thanks so much. That is a nice idea and I will write that down for a future video. Much appreciated.

@boodahbellie 2 ай бұрын

Randy, did you know, when you want to copy a line or lines of code like you did in this video, all you have to do is select the part you want to copy (like you did) and hold CTRL and drag the selection to the new location? Might be a good tip for the newbies.

@ExcelForFreelancers 2 ай бұрын

Great tip thanks so much. I will be practicing that even more than before. Thank you for your Likes, Shares & Comments. It really helps.

@abhaychamyal7730 2 ай бұрын

Thanks"Great VBA class! Your explanations are so clear and helpful. Could you please consider doing an email master class next time? It would be really beneficial for us learners. Looking forward to more tutorials from you!"

@ExcelForFreelancers 2 ай бұрын

Hi and thanks. I think that is a great idea. I have many on email, however nothing for basic learners. I will get it done this week. Thanks again

@abhaychamyal7730 Ай бұрын

Thank you so much for your guidance! I'll definitely look forward to your video and learn how to automatically save files from specific Mail to a specific folder. I'll patiently await it.

@ExcelForFreelancers Ай бұрын

Hi and thanks if you are looking to save email to a folder you can check out this training series here: kzbin.info/aero/PLIBeRriXvKzCtG5-PCCrGmlarvBC0UlGI I hope this helps and thanks so much.

@abhaychamyal7730 Ай бұрын

Thank you so much

@ahmedamer-kozika 28 күн бұрын

I am not finished my comment :D. So, for anyone who want mastering Excel VBA, Mr. Randy is the boss. Anyway, thank you very much Randy for your great efforts and may success follow you every step of the way.

@ExcelForFreelancers 27 күн бұрын

Thank you so very much, I really appreciate that Ahmed. very kind of you

@graytonw5238 2 ай бұрын

Interesting! I think FSO is more comprehensive as far as methods and properties (and it's cool to use too), but I didn't realize there was actually a VBA equivalent for some of these common uses.

@ExcelForFreelancers 2 ай бұрын

Yes thanks so much. I tend to use both during applications depending upon the application requirements. Thank you for your Likes, Shares & Comments. It really helps.

@sahralsahri7180 Ай бұрын

You are the best. ⭐⭐⭐⭐⭐

@ExcelForFreelancers Ай бұрын

Thank you so very much, I really appreciate that

@GosCee 2 ай бұрын

Wonderful! This is essential stuff, Randy. Thank you very much.

@ExcelForFreelancers 2 ай бұрын

Great, and thanks so much. I am really glad you enjoyed the training

@VS-rh8rq 2 ай бұрын

Thanks Appreciate it

@ExcelForFreelancers 2 ай бұрын

For sure, you are very welcome and I am happy to help and share

@khobk4436 2 ай бұрын

Thanks for the course, this is really make easy for my some macros.

@ExcelForFreelancers 2 ай бұрын

Great. I am very happy to help and share and glad you love the training

@peterwooldridge7285 2 ай бұрын

Smashing. My only criticisms are: 1) how does one know if something is an object 2) why and when does one know when to use "script"

@ExcelForFreelancers 2 ай бұрын

Hi and thanks very much Peter. I do have an entire video on objects here: kzbin.info/www/bejne/sJixkImEiMygm8k VBA code is great anytime you want to use automation or do take actions on things like a button click or worksheet event. I hope this helps and thanks so much.

@peterwooldridge7285 2 ай бұрын

@@ExcelForFreelancers thanks so much

@oliviertawamo1420 2 ай бұрын

Thanks for this formation it very good for us

@ExcelForFreelancers 2 ай бұрын

For sure, you are very welcome Oliver and thanks for your many years of support. I really appreciate it

@wimschiphorst8541 2 ай бұрын

good educational video. 2 questions. Is this late binding or early binding? These examples are static. perhaps in the future an instruction video on how you can define the folder or file yourself from a form, for example. Thx

@ExcelForFreelancers 2 ай бұрын

Hi and thanks so much. This uses late binding so that there is no need to attach additional libraries. I hope this helps and thanks so much.

@Info-God 2 ай бұрын

Great video. I use shell...combined with dictionary to store the files names. Is faster than fso. But this is me.

@ExcelForFreelancers 2 ай бұрын

Great information. Thank you for your Likes, Shares & Comments. It really helps.

@henkvinck888 2 ай бұрын

Top............Thank you very much.

@ExcelForFreelancers 2 ай бұрын

Thanks so very much Henk. I really appreciate your continued support.

@sanathanisvolgs 2 ай бұрын

Thanks for the info..

@ExcelForFreelancers 2 ай бұрын

For sure, you are very welcome and thanks so much for watching

@ziggle314 2 ай бұрын

Great work. FIrst time watching. I will be back.

@ExcelForFreelancers 2 ай бұрын

Awesome. Thanks so much and great to have you here :)

@ericmorgan2285 2 ай бұрын

I need to figure out how to use relative references. Any suggestions?

@ExcelForFreelancers 2 ай бұрын

Hi and thanks. It depends what type of references. You can search the use of the INDIRECT function. I hope this helps and thanks so much.

@Dexter101x 2 ай бұрын

Oooh this is dangerous stuff

@ExcelForFreelancers 2 ай бұрын

For sure not dangerous but very powerful and helpful. Thank you for your Likes, Shares & Comments. It really helps.

@abouyoussef555 13 күн бұрын

Hi sir... What about filepicker If show =-1..... Please a tutorial

@ExcelForFreelancers 13 күн бұрын

Hi and thanks very much. the -1 means a file has been selected. I hope this helps and thanks so much.

@akkintouch 2 ай бұрын

Is it possible to check if the file is open by someone else no matter a normal file or shared file?

@ExcelForFreelancers 2 ай бұрын

Hi and thanks you can check the FSO library of commands. It may be possible with the FIle System Object however I have not personally researched it at this time. Thanks again for your continued support.