Saving in a folder (and subfolders) based on user input

[Wanting_To_Learn]

I am using a Form to set values of variables. I then want to use these values to direct excel where to save the file.

Please Login or Register  to view this content.

I keep getting an error when the file tries to save, saying that it cannot find the file. Could someone please help, thanks in advance.

Stayci

[tigeravatar]

Stacyi,

If a workbook tries to save in a folder location that doesn't exist, you'll get an error. I'd recommend adding to your code a check to see if the folder exists already and if it does, just save the workbook, otherwise create the folder and then save the workbook:

Please Login or Register  to view this content.

Hope this helps,
~tigeravatar

[tigeravatar]

Stacyi,

It occurred to me that the macro might have to make several folders to get to the desired folder that it is being saved to. Unfortunately, the macro will fail if it has to create more than one folder. So I modified the code to provide a loop that will create each subfolder so that the workbook can be saved in the desired location:

Please Login or Register  to view this content.

Hope that helps,
~tigeravatar

[Wanting_To_Learn]

Thank you Tiger

The second code worked perfectly. I do find it odd because the folders were there, but, this seems to do the job. Thanks again!

Stayci