Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"run-time error '1004' - select method of range failed" | Excel Programming | |||
Run-time error "1004" Select method of range class failed | Excel Discussion (Misc queries) | |||
Run-time error '1004' at "Application.Calculate" | Excel Programming | |||
Run time error 1004: "No list was found.." | Excel Programming | |||
"Run-time error '1004'" Method 'Range' of object '_global' failed. | Excel Programming |