Help/Assistance/Guidance in "tidying" up code used to generate multiple folders and files

I'm a bit lost as to how your code works - Filename2.xls is saved as another name and then on the next loop it would no longer exist and you would get an error when you try to activate it?

Filename1 contains a list of names and other parameters, the code copies this name and updates a cell in filename2. I then use ".calculate" to refresh filename2 which uses vlookups to refer to the parameters in filename1, thus overwriting the original document. Filename2 is then saved in a new directory using the name copied over from filename1.

So on the second run through of the loop, filename2 no longer exists, as it has been saved with a new name, which will create an error?

No, the "Workbooks.Open Filename:=strBasis, UpdateLinks:=0" code reopens filename2 to allow the code to input the next name on the list and produce the next new spreadsheet.

The reason for producing this code was to take the manual aspect out of creating 100+ seperate spreasheets all in seperate folders.

strBasis is a file called "Jun13_base_AssumptionsTemplate_Assumptions.xls". Not "filename2.xls"...

It might be better if you upload the actual code you are using???

Updated above

perhaps:

Please Login or Register  to view this content.

Thanks for the reply, I get a run time error 13 - type mismatch with that though. It occurs on the "Set wb1 = Windows("WPSF Run Specification June 2013_ICA_RiskAgility2.xlsm")" line.

Maybe

Please Login or Register  to view this content.

then?