Macro to add additional word in file name

[Dnakr]

Here is an example of one of the file names used: Export_20130528 - 226.XLS

I have the file name listed in cell P3. What I need is the macro to automatically save the file as Export_20130528 - 226 (REVISED).XLS

Thank you.

[dilipandey]

Hi Dnakr,

In p3 enter "Export_20130528 - 226" - without quotes
and use below macro:-

Please Login or Register  to view this content.

Regards,
DILIPandey
<click on below * if this helps>

[Dnakr]

Thank you DILIPandey, worked great.

Could I bother you for one more thing? How can I tell it to save to a certain folder?

[dilipandey]

Okay... in that case you can update the save as code line as ActiveWorkbook.SaveAs Filename:="C:\Users\DILIPandey\Desktop\" & i


Regards,
DILIPandey
<click on below * if this helps>

[Dnakr]

Thank you worked great.

[dilipandey]

you are welcome..... cheers



Regards,
DILIPandey
<click on below * if this helps>