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

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