Run time Error "1004":
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 |
Run time Error "1004":
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 |
All times are GMT +1. The time now is 02:36 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com