Thanks for posting this very helpful video on automating folder creation. For my applications, I make use of the FileSystemObject object, which has more methods and functions like FolderExists(), FileExists(), the Folders collection and the Files collection. To take the solution to the next level, the range containing the folder names could be turned into a table. That way, the button could iterate through the table column without the user having to select the cells to be processed. Thank you kindly.
Great stuff! Thank you. I made attempt once in the past to create sub for changing time stamp of the file. I failed 🤷♂. I wonder if this can be done today with excel VBA ?
When you say “time stamp” do you mean the created and modified dates? If so, I suspect they are controlled by the core Windows operating system and not available for writing. Why would you need to change these?
@@ExcelOffTheGrid Windows sorts files in folder with modified date. Because of some reason when I copy pictures from one folder (e.g. SD card) to another (my archive folder on desktop) it overrides time stamp and sort order doesn't reflect timeline anymore. Surely this happens to folders after they are accessed. My plan was to read date created from EXIF record of the pictures and copy it to the modified date attribute of the file. I still haven't found a solution to that.
Very nice method. We could even have as an input cell the parent directory that is same in all the directories listed and not have to input it that many times and be easier to change parent directory if needed. Eg from user to user or project to project.
Hello Sir, I have excel 2000, how can I do Table in excel 2000, Having table will help drop down list to grow as the list of stock grows. I tried few different ways but table doesn't seem to work.
Tables were a feature originally added in 2003 under the name of Lists. Then given more features and renamed to Tables in 2007. So, it’s not in Excel 2000. Maybe it’s time to upgrade?
@@ExcelOffTheGrid , Thanks You Sir, I have worked out another way keep blanks off the drop down list and incremental list by using NAMED RANGE with code =OFFSET(RANGE,0,0,COUNTA(ColRange)-5,1) This worked for me, Thanks Sir for your help.
Excellent information Mark. I am doing tests. In my case it creates a subfolder if the folder already exists. If the folder does not exist, it does not create the folder with subfolders. Is this correct? I have to check.
Thanks Ivan. You are correct. It creates the last folder in the text string, if it can. So the parent folder must already exist. It does not create all folders in the text string.
Wow, somehow I didn't realize Selection could be used in that way, just taking the value of what is selected. For some reason I thought it had to be a cell or range object that was selected. Not necessarily the value in that range or cell
Thanks for posting this very helpful video on automating folder creation.
For my applications, I make use of the FileSystemObject object, which has more methods and functions like FolderExists(), FileExists(), the Folders collection and the Files collection.
To take the solution to the next level, the range containing the folder names could be turned into a table. That way, the button could iterate through the table column without the user having to select the cells to be processed.
Thank you kindly.
Agreed. If you want to get more advanced. That is the way to go 😁
I guess the FolderExists() method could be used as opposed to "On Error, Resume Next" in this solution?
Your work on automating Excel is really inspiring me. Thanks for all you do!
This is just the tip of the iceberg. We save the best stuff for our training courses 😁
Excellent ! Thank you for sharing your knowledge🙏
Great stuff! Thank you. I made attempt once in the past to create sub for changing time stamp of the file. I failed 🤷♂. I wonder if this can be done today with excel VBA ?
When you say “time stamp” do you mean the created and modified dates?
If so, I suspect they are controlled by the core Windows operating system and not available for writing.
Why would you need to change these?
@@ExcelOffTheGrid Windows sorts files in folder with modified date. Because of some reason when I copy pictures from one folder (e.g. SD card) to another (my archive folder on desktop) it overrides time stamp and sort order doesn't reflect timeline anymore. Surely this happens to folders after they are accessed.
My plan was to read date created from EXIF record of the pictures and copy it to the modified date attribute of the file. I still haven't found a solution to that.
Thank you!! This is smashing 👏
You're welcome. I hope you can put the knowledge to good use.
Brilliant!
Thanks 👍
I need to look into automation more
This is a lot of power in even a small amount of time investment.
Wonderful Thank you much !
Thanks. I'm glad you like it. 😁
Very nice method. We could even have as an input cell the parent directory that is same in all the directories listed and not have to input it that many times and be easier to change parent directory if needed. Eg from user to user or project to project.
Yes, you are right - it’s just text. So manipulate it however you like. 👍
Hello Sir, I have excel 2000, how can I do Table in excel 2000, Having table will help drop down list to grow as the list of stock grows. I tried few different ways but table doesn't seem to work.
Tables were a feature originally added in 2003 under the name of Lists.
Then given more features and renamed to Tables in 2007.
So, it’s not in Excel 2000. Maybe it’s time to upgrade?
@@ExcelOffTheGrid , Thanks You Sir, I have worked out another way keep blanks off the drop down list and incremental list by using NAMED RANGE with code =OFFSET(RANGE,0,0,COUNTA(ColRange)-5,1) This worked for me, Thanks Sir for your help.
Excellent information Mark. I am doing tests.
In my case it creates a subfolder if the folder already exists. If the folder does not exist, it does not create the folder with subfolders.
Is this correct? I have to check.
Thanks Ivan.
You are correct. It creates the last folder in the text string, if it can. So the parent folder must already exist. It does not create all folders in the text string.
Wow, somehow I didn't realize Selection could be used in that way, just taking the value of what is selected. For some reason I thought it had to be a cell or range object that was selected. Not necessarily the value in that range or cell
Selection is a relative object. So it changes depending on what is selected.
VBA makes some assumptions for us to ensure the code runs correctly.
This is a bit of an implementation of "Lazy Initialization", correct?
en.wikipedia.org/wiki/Lazy_initialization
I don’t think it is Lazy Initialisation in this case.
If we had used Late Binding in VBA, then that would be Lazy Initialisation.
@@ExcelOffTheGrid because we are completing our initialization during run time?