Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 :) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 :) |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Rename of sheets by macro | Excel Discussion (Misc queries) | |||
rename a workbook using a macro | Excel Programming | |||
Rename Macro | Excel Discussion (Misc queries) | |||
rename macro | Excel Programming | |||
macro to select next and rename | Excel Programming |