ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Run-time error '1004'; Document not saved - intermittent (https://www.excelbanter.com/excel-programming/348254-run-time-error-1004%3B-document-not-saved-intermittent.html)

Kerry

Run-time error '1004'; Document not saved - intermittent
 
ChDir "directory$\Phones\Telephone Directories\MASTER"
Application.ActiveWorkbook.SaveAs Filename:= _
"directory$\Phones\Telephone
Directories\MASTER\LatestContactList.xls", FileFormat:= _
1, Password:="", WriteResPassword:="", ReadOnlyRecommended:=False _
, CreateBackup:=False

This coded only works about 1 out of 10 tries. The other 9 times it gives
the error message in the subject. Any suggestions? Thanks.


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com