Macro to rename .doc
 

Hi,
I'm hoping that I can get some help here. I haven't written an excel macro
before. There is one goal that I am trying to accomplish:
I have two colums in a table, Old_Number and New_Number, then I have a
separate file with word documents that are named and saved under the old
number. Now there is not an Old_Number for every New_Number.

Is it possible to run down the Old_Number column, and everywhere that a
value appears, to have excel open up that particular document and perform a
'save as' function under the name of New_Number, maybe even into a new folder?

Any input is much appreciated :)

Macro to rename .doc
 

See the Name function
http://www.rondebruin.nl/folder.htm

You can loop through your list and name the files

--
Regards Ron de Bruin
http://www.rondebruin.nl



"InventoryQueryGuy" wrote in message
...
Hi,
I'm hoping that I can get some help here. I haven't written an excel macro
before. There is one goal that I am trying to accomplish:
I have two colums in a table, Old_Number and New_Number, then I have a
separate file with word documents that are named and saved under the old
number. Now there is not an Old_Number for every New_Number.

Is it possible to run down the Old_Number column, and everywhere that a
value appears, to have excel open up that particular document and perform a
'save as' function under the name of New_Number, maybe even into a new folder?

Any input is much appreciated :)

Macro to rename .doc
 

Very nice article, Ron.

Best wishes Harald

"Ron de Bruin" skrev i melding
...
See the Name function
http://www.rondebruin.nl/folder.htm

Macro to rename .doc
 

Thanks Harald

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Harald Staff" wrote in message ...
Very nice article, Ron.

Best wishes Harald

"Ron de Bruin" skrev i melding
...
See the Name function
http://www.rondebruin.nl/folder.htm