VBA auto naming when saving files

I could do with some help, i've created a short macro that basically rearranges and calculates a large table of data and then saves the new file. Is there anyway to code the macro so that it saves the new file as the old file name . Currently it always saves the output as book 1. Which is annoying as i have to run this file several times.

Any help/Advice would be much appreciated.

Comments

Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories