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.


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!