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.
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.
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.
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
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.
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.
