| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
error 1004 Method SaveAs of Workbook failed
I'm trying to save a backup copy of a macro-created workbook as a CSV. The
workbook has a single sheet. This line fails with a 1004 error: oExcelApp.activeworkbook.SaveAs filename:="L:\aTest\Sent\Trades_" & Format(date, "yyyy-mm-dd"), FileFormat:=xlCSV, CreateBackup:=False Anyone have any ideas? When I try a SaveAs manually I get a dialog -- if this is the problem, how can I avoid this? Maury |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Error 1004: Calculate Method of Range Class Failed | Excel Programming | |||
| Error 1004 Method 'Add'of Object Sheets failed | Excel Programming | |||
| RT Error 1004, Select method of worksheet class failed | Excel Programming | |||
| Error 1004: Method 'Cells' of object '_Global' failed | Excel Programming | |||
| Error Excel: 1004 SaveAs method of Workbook class failed | Excel Programming | |||
Threaded Mode
