[MS_AccessPros] Easy VBA code to change file name question

 

Hello all,

I have code that changes the name of a file in a folder with the data at the end of the file name. It works great however I would like to put a space between the name of the file and the date. I have added the " " in the path but vba does not like anything I try. Below is the code

Thank you

Jim Wagner

Name "W:\BUDGETING_FINANCE\STUDENTWORKER\ReportsArchive\Jim Wagner.pdf" As "W:\BUDGETING_FINANCE\STUDENTWORKER\ReportsArchive\Jim Wagner" & Format(Date, "mmddyyyy") & ".pdf"

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 4
• New Files 2

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___