Copying worksheets via VBA causes run-time error 1004

**neilshaw** · 05-10-2011, 05:15 PM

Hi there,

I am running the following code, original created by Jerry Beaucaire:-

Please Login or Register  to view this content.

Due to the number of sheets that I am attempting to copy I get an error 1004. I have found some code at the following link in the 'Resolution' section:- http://support.microsoft.com/kb/210684/en-us

Does anyone have an idea on how I go about incorporating this into my code?

The xls file is here-

http://dl.dropbox.com/u/297575/Excel%20Forum%20Copy.xls

I look forward to any suggestions.

Thanks

Neil

**JBeaucaire** · 05-13-2011, 03:30 AM

As I think about it, if you have THAT many sheets to copy, I wouldn't do it this way at all. I would create a template file with all these extra sheets in it and the template sheet to fill out already titled INPUT. I would have a macro in a second workbook with the DATA.

The macro would open the already existing generic template file, fill out the INPUT sheet and save/close with the correct filename, repeat for the next row of data. No copying of sheets...everything already exists in the template file being opened fresh for each iteration of input.

**neilshaw** · 05-23-2011, 02:52 PM

Great news Jerry that it would be possible using that method. Do you have any code that I can use as starting point at all? I am a beginner so I am only currently able to tweak code and this is my most ambitious project to date!

Any help would be appreicated

Thank you