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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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