Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can I display the current XLS filename in a toolbar? | Excel Discussion (Misc queries) | |||
Converting a Variable Filename to a Constant Filename | Excel Programming | |||
Filename with current Date() | Excel Programming | |||
Filename with current Date() | Excel Programming | |||
Append current date to filename | Excel Programming |