Thanks, this was exactly what I needed to know. The "Dir" function was completely new to me. I watched this video and was able to build my code with no problems at all. Thanks again.
Very good explanation, thank you very much. I offen use FileSystemObject method instead of Dir one because it provides more flexiblity for me. Also, when I use FSO, I can learn more things for example windows file directory info like hard disc size, name or file paths including extentions, modification dates, establishing dates etc. Can you make an handy video about File System Object usage?
Great tutorial, brilliantly explained going step by step through. This part of the code is something I was looking for to append workbooks (containing one sheets each) on top of each other something similar to power query. Thank you for the video. 👍🍀
Excuse me, but what about differencies between EXCEL for WINDOWS against for MAC in managing Files-Folders propriety? have you got some video on this topics?
@TeachExcel - we had a macro that was working perfectly. Then updated to Windows 11 and it didn't even open. We did the unblocking etc., and now it will only read one file inside the folder where all them are. What could be wrong with it?
@TeachExcel - I had a macros that was working perfectly, then updated to Windows 11 and it all went crazy. After I was finally able to unblock the security issues, it started to work but it's only capturing the data in one file inside the directory/folder where it's supposed to pull all the data from (there are 9 total files there). What could the problem be?
Seen many vba tutorials, u got the right way to do this. Great work. Thank u.
Thanks, this was exactly what I needed to know. The "Dir" function was completely new to me. I watched this video and was able to build my code with no problems at all. Thanks again.
You're very welcome Jeff! I'm glad I could help!
Very good explanation, thank you very much.
I offen use FileSystemObject method instead of Dir one because it provides more flexiblity for me. Also, when I use FSO, I can learn more things for example windows file directory info like hard disc size, name or file paths including extentions, modification dates, establishing dates etc.
Can you make an handy video about File System Object usage?
Cool....I didn't realise Geoff Goldbloom was such an Excel expert!
Good Tutorial!
Thank you for precise and simple explanations. Found it very useful
Like the videos. How about looping through another workbook to find a value. Kind of like a vlookup or xlookup with a press of a button.
Thank u very much for your hard work. A quick question: do you have any tutorial on class modules in VBA ?
I really liked the flow.
thank you bro, great tutorial!!!
Great tutorial, brilliantly explained going step by step through. This part of the code is something I was looking for to append workbooks (containing one sheets each) on top of each other something similar to power query. Thank you for the video. 👍🍀
Do you have a code or a tutorial video on how to generate a worksheet file whether its excel or csv format. Using vba template.
Very very helpful!!!!!!
Great video and amazing stuff
Excuse me, but what about differencies between EXCEL for WINDOWS against for MAC in managing Files-Folders propriety? have you got some video on this topics?
@TeachExcel - we had a macro that was working perfectly. Then updated to Windows 11 and it didn't even open. We did the unblocking etc., and now it will only read one file inside the folder where all them are. What could be wrong with it?
@TeachExcel - I had a macros that was working perfectly, then updated to Windows 11 and it all went crazy. After I was finally able to unblock the security issues, it started to work but it's only capturing the data in one file inside the directory/folder where it's supposed to pull all the data from (there are 9 total files there). What could the problem be?
Can we get the list of word document also?
Bonjour
Merci pour votre partage
Ma macro ne fonctionne pas au niveau de copy:=
Pourriez-vous svp m’aider
Fred
How do I do this for OneDrive online storage
Good video