Jim-
Try:
Name "W:\BUDGETING_FINANCE\STUDENTWORKER\ReportsArchive\Jim Wagner.pdf" As
"""W:\BUDGETING_FINANCE\STUDENTWORKER\ReportsArchive\Jim Wagner " & Format(Date,
"mmddyyyy") & ".pdf"""
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of luvmymelody
Sent: Thursday, August 25, 2011 8:58 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [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"
------------------------------------
Yahoo! Groups Links
Tidak ada komentar:
Posting Komentar