Hi, I'm new to the excel forum and have found some very helpful threads so far, but have a question of my own:
I used this thread: http://www.excelforum.com/excel-prog...readsheet.html to create a macro that makes new file folders in my chosen directory.
It worked great, but I want to edit it to also create the same 3 subfolders in every new folder: Correspondence, Establishment, and Financials
How do I do this??
Thank you in advance!
- Mikhaela
using the example Mkdir pathAndFolder is the bit that creates the folder. So all you need to do is add three extra lines with the additional folders eg: Mkdir pathAndFolder & "\Establishment"
click on the * Add Reputation if this was useful or entertaining.
Thank you very much, Tony!
Next questions (there are 3!):
1. How do I add a function to the macro so that if the folder already exists, it just skips over the row?
I know it's something along the lines of:
If (folder)=0 then
2. How do I add a function the macro so that if the row is empty, it just skips over it?
3. How do I change the macro so if there is something in columns E & F, it adds them as subfolders?
Thank you in advance!!
- Mikhaela
I suggest you post the code you have so far. And don't forget to use code tags (Item 3 in Forum Rules)
I know it's not very neat but this is what I have so far!!
Any help is appreciated
I need help especially with the If statements.
Please Login or Register to view this content.
I need to know what to put in there so that if there is contents in the E,G, or H cells, the folders will be created.
Last edited by mikmez; 03-06-2014 at 08:09 PM.
It is nearly one in the morning here but I will give you a quick pointer. there are various ways to test for an empty cell
or use <> for not equalPlease Login or Register to view this content.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks