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
,
As long as ever you can.” - John Wesley
-
From: suresh k brave.sur...@gmail.com
To: Excel group excel-macros@googlegroups.com
Sent: Fri, January 25, 2013 7:15:19 AM
Subject: $$Excel-Macros$$ Save excel with date
Hi,
I am
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,