#1
|
|||
|
|||
saveAs ChDir _
Code:
Sub saveFile() Dim newFile As String, fName As String fName = "test" newFile = fName & " " & Format$(Date, "yyyy-mm-dd") ChDir _ "C:\Users\Tin\Desktop\" ActiveWorkbook.SaveAs Filename:=newFile End Sub It is fine. If I use ChDir _ even the location path is correct the file will be saved in my Document Folder Why? Code:
Sub saveFile() Dim newFile As String, fName As String fName = "test" newFile = fName & " " & Format$(Date, "yyyy-mm-dd") ActiveWorkbook.SaveAs "C:\Users\Tin\Desktop\" & newFile End Sub |
#2
|
||||
|
||||
Hi tinfanide,
Try: Code:
Sub saveFile() Dim Strfold As String, StrNewFile As String, StrfName As String StrfName = "test" Strfold = "C:\Users\Tin\Desktop\" StrNewFile = Strfold & fName & " " & Format$(Date, "yyyy-mm-dd") ActiveWorkbook.SaveAs FileName:=StrNewFile End Sub
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Oh... does that mean ChDir is not for locating directories?
|
#4
|
||||
|
||||
Hi tinfanide,
ChDir is for changing directories, not for finding them.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#5
|
|||
|
|||
I see. Thanks.
|
|