get the current filename as a variable
ActiveWorkbook.Name will give you the file name.
ActiveWorkbook.FullName will give you the file name and the full path.
ActiveWorkbook.Filename is not available.
"Janis" schreef in bericht
...
The myFileName line does not compile. What I want to do here is save the
current filename with the date appended. I am trying to put the current
filename into the Sub
tnx,
saveIndesign()
'Appends date to filename so as to not write over an existing file
Const fPath As String = "Mac OS X:Users:jrough:Documents"
Dim fName As String
Dim myFileName As String
myFileName = ActiveWorkbook.Filename
fName = fPath & myFileName & Time()
ActiveWorkbook.SaveAs Filename:=fName
End Sub
|