Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35,218
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
"run-time error '1004' - select method of range failed" maemi weirdoke Excel Programming 2 March 5th 08 03:15 PM
Run-time error "1004" Select method of range class failed Tallan Excel Discussion (Misc queries) 3 March 7th 07 05:22 PM
Run-time error '1004' at "Application.Calculate" PCLIVE Excel Programming 2 March 2nd 07 04:32 PM
Run time error 1004: "No list was found.." hachiroku[_5_] Excel Programming 1 May 22nd 06 12:53 PM
"Run-time error '1004'" Method 'Range' of object '_global' failed. haisat[_2_] Excel Programming 0 October 20th 03 12:13 PM


All times are GMT +1. The time now is 09:39 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"