How To Loop Through Files To Automate ANYTHING - Excel VBA Basics Series

[@ExcelForFreelancers]

🎄 𝗦𝗮𝘃𝗶𝗻𝗴𝘀 𝗔𝘀 𝗕𝗿𝗶𝗴𝗵𝘁 𝗔𝘀 𝗖𝗵𝗿𝗶𝘀𝘁𝗺𝗮𝘀 𝗟𝗶𝗴𝗵𝘁𝘀 - 𝗨𝗽 𝗧𝗼 𝟱𝟱% 𝗪𝗮𝗶𝘁𝗶𝗻𝗴 𝗙𝗼𝗿 𝗬𝗼𝘂! 👉 www.excelforfreelancers.com/XmasSale2024_YTPinnedComm

[@ExcelForFreelancers]

⚡ 𝗦𝗜𝗠𝗣𝗟𝗜𝗙𝗬 𝗖𝗢𝗠𝗣𝗟𝗘𝗫 𝗘𝗫𝗖𝗘𝗟 𝗧𝗔𝗦𝗞𝗦 𝗜𝗡𝗦𝗧𝗔𝗡𝗧𝗟𝗬 𝗪𝗜𝗧𝗛 𝗘𝗫𝗖𝗘𝗟 𝗔𝗜 𝗧𝗢𝗢𝗟𝗣𝗔𝗖𝗞 𝗔𝗗𝗗-𝗜𝗡 👉 www.excelforfreelancers.com/ai-toolpack

[@rb-today]

Hi Randy, Thanks for this training. I use the FSO object to create backups of my files. I can check if the path exists & create a new path with date & time stamp, if required. I learn something from your videos that I can adapt to my code. I'm looking into making backups for my backups on another drive. Then over writing the older files. (I'm retired and I think of projects to keep my mind active.)

[@ExcelForFreelancers]

Hi Robert, thanks so much for sharing and this is a great idea. No doubt having backups is essential and you can run the macro on a recurring basis so its more of a 'set it and forget it' type of task. I hope this helps and thanks so much.

[@didiertheunpreditable4763]

Hi Randy, thanks so much. I really appreciate1

[@ExcelForFreelancers]

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

[@ranilan00]

Just created a loop like that this afternoon! Can't wait to learn things I missed ❤

[@ExcelForFreelancers]

Oh Excellent. I am sure you will love this training. Thanks again for your continued support.

[@nerenlakhraj5252]

Hi Randy ... Always a new learning experience ... Thank you

[@ExcelForFreelancers]

Great, thanks so much Neren. I am so happy that you still find value, even in these Basic VBA videos. I always appreciate so many years of support. Thanks again

[@drojanprojectchannel]

Hi there Randy .. good to learn new vba lesson from you again. Thank you for emailing me always

[@ExcelForFreelancers]

For sure, you are very welcome and I am happy to help and share. I am glad you enjoyed it

[@Sancarn]

Hi Randy, Love how you're creating so much VBA content. A suggestion: You might want to indent the code in your subs, especially if you're making tutorials for people online. What are your thoughts?

[@ExcelForFreelancers]

Hi and thanks so much. Almost all of my code is indented. I do like to keep it organized. If you want to view the code in a color coded and fully-organized method. that is also automated with my PDF codebooks on my Patreon platform each week www.patreon.com/ExcelForFreelancers I hope this helps and thanks so much.

[@Sancarn]

@@ExcelForFreelancers Interesting that you provide codebooks to your patreons :) I'm not really a consumer of this type of content, I maintain VBA libraries mainly on github :) E.G. stdVBA. It was just something I noticed 😁

[@ExcelForFreelancers]

Ah no worries at all. I also create an updated training, template and resources on Patreon as well. I have a few hundreds videos right here on KZbin as well. Thanks again

[@abouyoussef555]

thanks sir.... the best to learn step by step

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that and I am so glad you like it

[@analistaribeiro]

When I saw 'FileName = Dir(FolderPath &"*.")' I thought 'FileName' receives JUST first one file and had to be incremented, but NOT! Would you explain this?

[@ymgexcel9499]

When making videos in one go, inaccuracies will happen. 'FileName = Dir(FolderPath & "*.*")' means the first file name is retrieved. Then in the loop, when 'FilelName = Dir' the next file name is retrieved. You can easily prove the latter by using 'Debug.Print "Current: " & FileName' before the line, and 'Debug.Print "Next: " & FileName' after the line.

[@ExcelForFreelancers]

@ymgexcel9499 explained it perfectly. It loops through the entire folder looking for all files that match the criteria. With the last line FileName = Dir its cleared and retrieved the next and will continue until FileName is nothing. It works quite beautifully. Thank you for your Likes, Shares & Comments. It really helps.

[@abdulsafwan711]

is that possible to list all extension, like filter

[@ExcelForFreelancers]

HI and thanks. yes for sure. You can add the filter such as "*.pdf" and then you can list them on a sheet, incrementing the rows such as Sheet1.Range("A" & RowNumb).value = Dir(FileName) RowNumb = RowNumb + 1 So just add that into the loop I hope this helps and thanks so much.

[@hectordominguez7143]

Is this possible in a sharepoint location?

[@ExcelForFreelancers]

Hi and thanks Yes sure it is. To share and sync your macro-enabled Excel workbook, please watch this training: kzbin.info/www/bejne/fWq5onltrrNjhdE

[@Chem.digital.study_tools]

Hello do u knw how to use Vba to use windows speech recognition

[@ExcelForFreelancers]

Hi and thanks so much. I have not worked with speech recognition however I will check it out. It is an interesting and helpful concept. Thank you for your Likes, Shares & Comments. It really helps.

[@Chem.digital.study_tools]

@@ExcelForFreelancers pls revisit it

[@henkvinck888]

Whaaaaauw Thnx Randy

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that Henk. I know this one is very basic for you, but the refresher may help. Thank you for your Likes, Shares & Comments. It really helps.

[@danp6101]

I use this to delete my temp folders, cookies and other useless stuff.

[@ExcelForFreelancers]

Oh yes that is a great idea. Its an awesome way to do a massive # of tasks with files and folders. (one of the best in my opinion) Thank you for your Likes, Shares & Comments. It really helps.

[@abouyoussef555]

Wait impatianly..

[@ExcelForFreelancers]

Thanks so much. You will love this one. Thank you for your Likes, Shares & Comments. It really helps.

[@henkvinck888]

Hello Randy, I see on the news bulletin huge devastation in China and Vietnam. I hope all goes well with your family and friends and that once again it is propaganda.

[@ExcelForFreelancers]

Hi Henk thanks so much for the concern. The storm was quite north of me, in Hanoi and norhern area. Here in central Da Nang, the weather has been quite nice, not nearly any rain at all. Thanks again for your kind concern

[@chrisk.9765]

e.g.. fileName = Dir(folderPath & "*.xml") Do While fileName "" fileNum = FreeFile Open folderPath & fileName For Input As #fileNum fileContent = Input$(LOF(fileNum), fileNum) Close #fileNum ... ... Loop

[@ExcelForFreelancers]

Hi Chris, Thanks so much for sharing and great to have you here