I have a macro that runs an application, and creates new files with the results. I want to have the date (and if possible time) of the run in my file name. But I am not able to do this with the Date function as I guess the results it throws is not in the text format. How can I do this in VB? Right now, to do this, I am typing the date in "" in one of the cellls, but I am sure there would be better ways. Suggestions please.
Thanks,
Kapil
Bookmarks