Using Word VBA to change file names in a directory

sg11 · #1 03-21-2018, 10:54 AM

I am trying to use
Name oldFile NewFile
But it fails because the Name is Identified as a String Variable with the value "Microsoft Office". This is not a variable that I entered, could not find where this was declared. Unable to change. It is constant.
Did not find any other way to rename files.
Help..?

Guessed · #2 03-21-2018, 06:53 PM

You forgot to include an as between the oldfile and newfile

Code:

Name oldFile As NewFile

sg11 · #3 03-21-2018, 09:33 PM

Just forgot to add it here ...

Guessed · #4 03-21-2018, 10:58 PM

In that example you haven't populated the two string variables so it would struggle to work...

Code:

Sub aTest()
  Dim oldFile As String, newFile As String
  oldFile = "C:\Work\My Pictures\image1.wmf"
  newFile = "C:\Work\My Pictures\image2.wmf"
  Name oldFile As newFile 
End Sub

I must say I am surprised this is a valid command to rename a file. Name 'should' be a reserved word and can be used to show the name of the application
ie
debug.print Application.Name
debug.print Name
Both the above lines would return a string that shows the name of the current application.

sg11 · #5 03-22-2018, 04:25 AM

Name command works
My problem was that
newName = "xxxx12 .png"
with space. When I removed the space it works.
Thanks

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Extracting list of embedded image file names from Word 2016	erik@haagensen.no	Word VBA	5	08-19-2017 11:02 PM
How capture a folder's file names to a file?	BobKnepper	Word	2	05-22-2016 07:30 AM
Copy and Paste from File to File but File Names always change	aaronbauer1980	Excel Programming	1	04-15-2016 05:53 PM
Replacing jpg file in each file of a directory	hklein	Word VBA	4	10-14-2013 04:40 PM
Change order of names to LAST / FIRST ?	Jack R	Outlook	1	07-05-2010 08:50 PM