Rampage123
01-30-2014, 07:42 AM
Hi all,
I am running a VBA based tool that I have made which calculate certain output.
Now, the problem is I run this tool multiple times a day and I would like to save each output in a separate excel file.
Is it possible to write a macro to create a separate excel file that contains current system date and time and export my output to that file each time so that I have each version of output saved.
If yes, can somebody share the code for such an exercise. I have searched online a bit, but with no use.
Thanks in advance.
I am running a VBA based tool that I have made which calculate certain output.
Now, the problem is I run this tool multiple times a day and I would like to save each output in a separate excel file.
Is it possible to write a macro to create a separate excel file that contains current system date and time and export my output to that file each time so that I have each version of output saved.
If yes, can somebody share the code for such an exercise. I have searched online a bit, but with no use.
Thanks in advance.