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

Kamis, 25 Agustus 2011

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

Hi Jim,

Place the space within the initial portion of the name. Note the space
after the second "C:\WS_FTP ". The following worked for me.

Sub RenameFile()

'WS_FTP.LOG

'C:\WS_FTP.LOG

'Name "W:\BUDGETING_FINANCE\STUDENTWORKER\ReportsArchive\Jim Wagner.pdf" As
_

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

Name "C:\WS_FTP.LOG" As "C:\WS_FTP " & Format(Date, "mmddyyyy") & ".LOG"

End Sub

Jeff

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