cu08senior
04-27-2009, 12:15 PM
Hey All,
I'm new here and starting to scratch the surface of VBA for excel. I've done a few simple commands and I know this one is going to be easy, so it'd be great to get some pointers real quick.
Essentially, I have a work book... I have several macros run, but when I'm done, I'd like to present a button to "Save as today's file" or something along those lines".
I'd like to Copy the Workbook, Open it in a New Window, Run some other code that I would record macro for (then plug it into the code), save and close workbook as filename =Range"A1" & format(now, dd-mm-yyyy).
etc..
How can I go about doing this? I don't seem to know the right commands. Thus far I can just saveas and close, but I dont want the original workbook to go away, its almost like a template I'm usuing to create daily outputs...
Thanks!
I'm new here and starting to scratch the surface of VBA for excel. I've done a few simple commands and I know this one is going to be easy, so it'd be great to get some pointers real quick.
Essentially, I have a work book... I have several macros run, but when I'm done, I'd like to present a button to "Save as today's file" or something along those lines".
I'd like to Copy the Workbook, Open it in a New Window, Run some other code that I would record macro for (then plug it into the code), save and close workbook as filename =Range"A1" & format(now, dd-mm-yyyy).
etc..
How can I go about doing this? I don't seem to know the right commands. Thus far I can just saveas and close, but I dont want the original workbook to go away, its almost like a template I'm usuing to create daily outputs...
Thanks!