Unanswered: Autonaming an Outputted Spreadsheet via Access Macro
I have a macro that runs and exports data to a spreadsheet on the users machine, is there any way to autoname the spreadsheet so that it corresponds to the current date. Currently the file name is Product_Inventory.xls, I would like to make it Product_Inventory 01-30-08 - where the date is the date that the access macro exported the data into the spreadsheet. Any help would be GREATLY appreciated.
Also, the specifics of naming a file on the filesystem (if you continue with what you have now) will involve either shelling a DOS command to the OS or using the filesystem object. The way you rename a file is by using the move method as I recall. One of VBA's file methods might be able to do it too but I can't remember.....