DidaDiogoDog
New Member
- Joined
- Aug 12, 2022
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
Hello, everyone!
I'm quite a noob when it comes to Excel, and I'm just giving my first steps on macros. So, I believe this might be quite simple for you, but I'm having a lot of trouble making this work.
Basically, I have a sheet with a lot (around 100) of different Windows paths on column A. (Someting like "C:\Users\Default\Documents\Jobs\Task1").
What I need is:
1) To have a macro that would create the last folder in all these paths (so, in the above example, the folder "Task1" would be created at "Documents\Jobs)
2) The previous folders to be created if they do not exist (so, for instance, if I had no folder called "Jobs" at "Documents", it would create the folder "Jobs" and, inside it, the folder "Task1")
3) The content of the paths that already exist not to be deleted/replaced (so, if the folder "Jobs" already existed and contained files, they cannot be deleted in order to create "Task1")
Is there a simple way to make this work?
Thank you so much!
I'm quite a noob when it comes to Excel, and I'm just giving my first steps on macros. So, I believe this might be quite simple for you, but I'm having a lot of trouble making this work.
Basically, I have a sheet with a lot (around 100) of different Windows paths on column A. (Someting like "C:\Users\Default\Documents\Jobs\Task1").
What I need is:
1) To have a macro that would create the last folder in all these paths (so, in the above example, the folder "Task1" would be created at "Documents\Jobs)
2) The previous folders to be created if they do not exist (so, for instance, if I had no folder called "Jobs" at "Documents", it would create the folder "Jobs" and, inside it, the folder "Task1")
3) The content of the paths that already exist not to be deleted/replaced (so, if the folder "Jobs" already existed and contained files, they cannot be deleted in order to create "Task1")
Is there a simple way to make this work?
Thank you so much!
