saveAs ChDir

		Microsoft Office Forums > Microsoft Excel > Excel Programming
saveAs ChDir _

FAQ

Thread Tools

Display Modes

11-04-2011, 03:57 AM

macropod

Windows 7 64bit saveAs ChDir _

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,387

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]

« Previous Thread | Next Thread »

Other Forums: Access Forums

All times are GMT -7. The time now is 09:47 PM.