File Rename from From

[Jason Lopez]

My boss has given me a scanning project where I am scanning many pages worth
of information. However, each page needs to be its own seperate scan.
After doing a giant batch scan, I am saving each scan under their
identifiable ID number. However, I also need to add the general ID number
to the file name.

So, I have created a query (that each scan is based off of in the first
place) that shows the name of each scan file as named during the seperation
process. But, I am needing to change that name to the new name. In the
query there is a field of OldName and NewName. Is there a script that I can
program into a button that will allow the name to change from the old to the
new?

One batch scan can yield 20-30 individual scans. Do the renaming by hand
would be a pain. Not to mention massive carpal tunnel.

Is there anything that can be used to assist in this.

Jason Lopez

 

[Albert D. Kallal]

There is a built in command called "name" that will do as you ask


eg:

name "oldfile" as "newfile"

 

[Jason Lopez]

Okay. I tried looking for it. I tried in the VB Code screen to search for
"name" and I got a bunch of results. But, what exactly should I be looking
for? Everything that I find is talking about renaming objects in the
database. I am looking to rename files that are not part of the database
but exist in a folder outside the database.

Jason

 

[Jason Lopez]

I found a command that works.

Jason

Okay. I tried looking for it. I tried in the VB Code screen to search
for "name" and I got a bunch of results. But, what exactly should I be
looking for? Everything that I find is talking about renaming objects in
the database. I am looking to rename files that are not part of the
database but exist in a folder outside the database.

Jason