Hello.
I have a created a Macro and in it I am using the transfer spreadhseet command. I am using scheduler to run this macro and everything works fine. But what I would like to do in the macro is when it transfers the spreadsheet that it gives it a new spreadsheet name each time. I am not a VBA user and am an intermediate Access user and wondering can this be done or not