Macro to rename .doc

[InventoryQueryGuy]

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

[Ron de Bruin]

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" <InventoryQueryGuy@discussions.microsoft.com> wrote in message
news:F25765F4-37D9-4808-B352-E8549F854435@microsoft.com...
> 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

[Harald Staff]

You don't have to open documents to rename/move them. Try something like

Sub test()
Name "C:\Temp\Book1.xls" As "C:\Data\Pornsong.mp3"
End Sub

HTH. Best wishes Harald

"InventoryQueryGuy" <InventoryQueryGuy@discussions.microsoft.com> skrev i
melding news:F25765F4-37D9-4808-B352-E8549F854435@microsoft.com...
> 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

[Harald Staff]

Very nice article, Ron.

Best wishes Harald

"Ron de Bruin" <rondebruin@kabelfoon.nl> skrev i melding
news:%23$ee94IvGHA.356@TK2MSFTNGP04.phx.gbl...
> See the Name function
> http://www.rondebruin.nl/folder.htm

[Ron de Bruin]

Thanks Harald

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



"Harald Staff" <innocent@enron.invalid> wrote in message news:%236ru9$IvGHA.4872@TK2MSFTNGP02.phx.gbl...
> Very nice article, Ron.
>
> Best wishes Harald
>
> "Ron de Bruin" <rondebruin@kabelfoon.nl> skrev i melding
> news:%23$ee94IvGHA.356@TK2MSFTNGP04.phx.gbl...
>> See the Name function
>> http://www.rondebruin.nl/folder.htm
>
>