NVRensburg
Board Regular
- Joined
- Jul 1, 2014
- Messages
- 113
- Office Version
- 365
- 2016
- Platform
- Windows
I've tried a couple examples from other posts but no luck yet. Please could someone help me with a code 
I have a workbook called "Subcontractor Spreadsheet". I want to create a macro that would create a new folder in location "J:\Alaska New Filing System (In Progress)\Tenders\Tenders by Project Number" named on the contents of cell B2 and then save the workbook as (save a copy in other words) filename in cell B3 and B2 (so I don't want to affect my master document.)
Thanking you in advance!

I have a workbook called "Subcontractor Spreadsheet". I want to create a macro that would create a new folder in location "J:\Alaska New Filing System (In Progress)\Tenders\Tenders by Project Number" named on the contents of cell B2 and then save the workbook as (save a copy in other words) filename in cell B3 and B2 (so I don't want to affect my master document.)
Thanking you in advance!