GetOpenFilenamd Method

[Dexter]

In one of my Vba books, I ran across example code that uses both the GetOpenFilename and the GetSaveAsFilename methods to rename files. I'm wondering if I could use this code along such that it references an open workbook containing a table of current filenames and desired filenames.

The idea would be to have the code use this table to rename a bunch of text files with no operator intervention.

Any help would be greatly appreciated.

 

[Andrew Poulsom]

You can use VB's name statement to do this:

Name Statement

Renames a disk file, directory, or folder.

Syntax

Name oldpathname As newpathname

The Name statement syntax has these parts:

Part Description
oldpathname Required. String expression that specifies the existing file name and location — may include directory or folder, and drive.
newpathname Required. String expression that specifies the new file name and location — may include directory or folder, and drive. The file name specified by newpathname can't already exist.

Remarks

The Name statement renames a file and moves it to a different directory or folder, if necessary. Name can move a file across drives, but it can only rename an existing directory or folder when both newpathname and oldpathname are located on the same drive. Name cannot create a new file, directory, or folder.

Using Name on an open file produces an error. You must close an open file before renaming it. Name arguments cannot include multiple-character (*) and single-character (?) wildcards

 

[Dexter]

Andrew,

Wow! Thanks for the help. I'll give it a try.