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
for example,
Activeworkbook.Save
VBA Tips & Tricks ([link=http://vbadud.blogspot.com]http://vbadud.blogspot.com[/link])
C# Code Snippets ([link=http:dotnetdud.blogspot.com]http:dotnetdud.blogspot.com[/link])
[url=http://pret-auto.org][color=#FFFFFF][u]pret auto[/u][/color][/url]
[url=http://pret-auto.org][color=#FFFFFF][u]pret auto[/u][/color][/url]