How do I save a spreadsheet from a macro?
I need to create a macro to "save as" the spreadsheet to a specific
folder, with a unique (date/time based) file name.
Is there a "save as" command that can be used from a macro so that
this can be done? I can sort out the file naming procedure, unless
you have any suggestions on that as well.
Thanks,
TK
|