Hi,

I have the following code. I am having trouble with the creat folder and save new workbook as. I want to create a folder named USD (USD is a value in the Sheet named ADMIN Cell B3. I then want to save each new workbook as the worksheet name & the currency from Sheet ADMIN Cell B3 & the year which is in Sheet ADMIN Cell B2.

My code is below. I am having trouble with the folder and the naming of the files.

Please Login or Register  to view this content.