Maybe wbn doesn't hold what you think -- not an open workbook name--and make
sure that wbn includes the extension)

Maybe sFileName doesn't hold what you think--invalid characters in the name???

Surabhi wrote:

Hello All,

This is regarding a error - Run time Error "1004" when i ran a macro.
When i debugged the macro it says "Workbooks(wbn).SaveAs (sFileName)".
Can anybody tell the possible cause of error.

Regards,
Surabhi

--

Dave Peterson