#1
|
|||
|
|||
Using Word VBA to change file names in a directory
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..? Last edited by sg11; 03-22-2018 at 04:27 AM. Reason: Solved |
#2
|
||||
|
||||
You forgot to include an as between the oldfile and newfile
Code:
Name oldFile As NewFile
__________________
Andrew Lockton Chrysalis Design, Melbourne Australia |
#3
|
|||
|
|||
No I did not in the VBA
Just forgot to add it here ...
Last edited by sg11; 03-21-2018 at 09:39 PM. Reason: want to add a file |
#4
|
||||
|
||||
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 ie debug.print Application.Name debug.print Name Both the above lines would return a string that shows the name of the current application.
__________________
Andrew Lockton Chrysalis Design, Melbourne Australia |
#5
|
|||
|
|||
Solved
Name command works
My problem was that newName = "xxxx12 .png" with space. When I removed the space it works. Thanks |
Thread Tools | |
Display Modes | |
|
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 |