 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / July 2007Running a macro and change file name
I was wondering if there was away to create a spreadsheet in excel, for instance my HR girl creates a database of all personel with their 401k info then she has to save this in a .prn extension. we wrote the Macro to name the file rename.prn. My question can we add to this macro so it automatically renames the file with the date it was written Example: 07102007.prn Name rename.prn Format(Date,"mmddyyyy") & .prn  Signature--- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) >I was wondering if there was away to create a spreadsheet in excel, > for instance my HR girl creates a database of all personel with their > 401k info then she has to save this in a .prn extension. we wrote the > Macro to name the file rename.prn. My question can we add to this > macro so it automatically renames the file with the date it was > written Example: 07102007.prn
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.