| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Document Not Saved Error | Excel Discussion (Misc queries) | |||
| Why do I get an error Document not Saved in Excel? | Excel Discussion (Misc queries) | |||
| Automation Error and Document not saved | Excel Programming | |||
| ERROR MESSAGE DOCUMENT NOT SAVED | Excel Discussion (Misc queries) | |||
| VB OLE embeded excel document cannot be saved -err 1004 | Excel Programming | |||
Linear Mode
