I want to export a table from Microsoft Access to Microsoft Excel, but I want to use current date as the file name. I want it to look like this mm_dd_yy.
I am using the "output to" macro right now, but I have to go and change the name of the file manually.
Anyhelp will be appreciated
then you should change acOutoutTable parameter to acOutputQuery, and you should type queryname instead "tablenamehere". other than that this should work. one more thing, this code is not a macro. it is VBA code. therefore you can't use it in a macro event. you should create it with code builder, not macro builder. no macros involved with this code.