View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Maury Markowitz Maury Markowitz is offline
external usenet poster
 
Posts: 86
Default 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