ACCESS FEED: Re: [MS_AccessPros] Easy VBA code to change file name question

Jumat, 26 Agustus 2011

Re: [MS_AccessPros] Easy VBA code to change file name question

Thank you everyone. I was able to get it working based on your code.

You developers are awesome

Jim Wagner
________________________________

________________________________
From: John Viescas <john@viescas.com>
To: MS_Access_Professionals@yahoogroups.com
Sent: Thursday, August 25, 2011 12:40 PM
Subject: RE: [MS_AccessPros] Easy VBA code to change file name question

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

[Non-text portions of this message have been removed]