Excel report error (VBA)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to save a record in a CSV file. Whenever I run the macro, I get
an error:

Run-time error '1004'
Method 'SaveAs' of object '_Workbook' failed

My code for this is:

Sub SaveCSV()
Property = Range("[Control.xls]Info!B2").Value
TodaysDate = Format(Now, "dd-mm-yy")
ActiveWorkbook.SaveAs Filename:="C:\Export\Files\" & Property &
TodaysDate & ".csv", _
FileFormat:=xlCSV, CreateBackup:=False
NewSaveName = Property & TodaysDate & ".csv"
End Sub

Any ideas on how to fix this? Help much appreciated.
 
Yeah, I finally figured that one out after hours of frustration. Thanks for
your reply!
--
Thanks, Dirk


Chip Pearson said:
Your code worked fine for me as long as the folder
C:\Export\Files exists. Are you sure that folder exists?


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

message
I am trying to save a record in a CSV file. Whenever I run the
macro, I get
an error:

Run-time error '1004'
Method 'SaveAs' of object '_Workbook' failed

My code for this is:

Sub SaveCSV()
Property = Range("[Control.xls]Info!B2").Value
TodaysDate = Format(Now, "dd-mm-yy")
ActiveWorkbook.SaveAs Filename:="C:\Export\Files\" &
Property &
TodaysDate & ".csv", _
FileFormat:=xlCSV, CreateBackup:=False
NewSaveName = Property & TodaysDate & ".csv"
End Sub

Any ideas on how to fix this? Help much appreciated.
Click to expand...
Click to expand...
 
Back
Top