Rename File

cksm4 · #1 02-24-2011, 08:03 PM

Hello,

I am trying to rename the active document using this code:

Code:

 
Sub RenameFile()
     Dim sOldPathName As String
     sOldPathName = "G:\DATA\Test.docx"
     On Error Resume Next
     Name sOldPathName As "G:\DATA\TestWorked.docx"
     If Err Then MsgBox Err.Description
End Sub

I get this error: "File/Path access error". Is it not possible to rename a open file?

Much thanks for any insite anyone can provide... I have spent a lot of time researching this.

Brock

macropod · #2 02-25-2011, 02:37 AM

Hi Brock,

No, you can't rename an open file.

cksm4 · #3 02-25-2011, 09:29 AM

Hey Paul,

Thanks for the reply... it answers my question! I will use the Kill command after the Name command to delete the old copy of the file. This will serve the same purpose. Thanks again Paul!

Brock

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Word Macro: Save file as text with current file name	jabberwocky12	Word VBA	2	10-22-2010 12:23 PM
Rename Outlook 2003 Contacts Folder	sfpermits	Outlook	6	07-21-2010 09:56 AM
linking a word file and an excell file on a macbook pro	Fleur	Office	0	07-14-2010 08:19 PM
How to open ppt file directly with slide show when clicked on file.	praveen_p	PowerPoint	1	05-06-2009 12:42 PM
code to save / rename / send attachments	unit213	Outlook	1	09-26-2007 08:15 PM