This works thanks Gawli Anil.
On Saturday, August 23, 2014 12:35:08 PM UTC-5, rjag...@aim.com wrote:
>
> *Create macro to save macro template as macro enabled workbook using cell
> value as file name*
>
> This is what I'm trying to do. Save the Macro Template on a network
> drive as a Macro
Well Paul there's a guy in England who says this formula works for him. I'm
awaiting his reply on another forum but he apparently doesn't log on to
often. I also know of another formula some claim to work the difference
being Value & ".xlsm" is replaced with Format=51. I can't get either to
wor
