Saving in the current directory with amended name

**jram** · 08-19-2009, 07:40 AM

Hi

i would like to be able to create a new version of the file which I am working on, but with a different name in whatever directory the file is originally saved in i.e.:

the macro will save the current file
then run some basic script to remove the formula
then save the file but with the name [current directory]\[current name]_figures.xls

Can you please help me with this.

Cheers
James

**JBeaucaire** · 08-19-2009, 08:33 AM

Please Login or Register  to view this content.

This will work on whatever the currently activeworkbook is, not just the book the macro is installed into.

**jram** · 08-19-2009, 09:24 AM

Thank you so much .... I really appreciate you taking the time to help me out.

Cheers
James

**JBeaucaire** · 08-19-2009, 11:00 AM

If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].

(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated)