VBA error code?

[samilynn]

I am running a macro which moves all worksheets in the active workbook to new workbooks in a specified folder.
However, lately I started getting this error message. Do you know what it means, and what I can do about it?
Thanks

An error has occurred. Error number =1004. Error description = Method 'SaveAs' of object '_Workbook failed.

 

[Damon Ostrander]

Hi samilynn,

The error simply means that the code can't do the SaveAs as requested. From what you have described I suspect it is because the code is trying to move all the sheets from the workbook, and this is illegal. A workbook must have at least one sheet. One way around this problem is to add a new blank sheet to the workbook:

Application.Worksheets.Add

I hope this helps.

Damon