Sub test()
Dim wkb As Workbook
Dim pth As String
Dim myname As String
pth = "C:\Documents and Settings\user\Desktop\"
myname = "ashish"
' or try this
'myname = Application.UserName
' or try this
'myname = Environ("username")
Set wkb = ActiveWorkbook
wkb.SaveAs pth & myname & VBA.Format(Date, "_dd
---
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-------------
Hi,
I am trying to save excel file using macro.. The file name should be
my name followed by today's date.
Is there any macro for this?
/Suresh
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor threa
