OutputTo File Naming Convention

[Brig]

I created a macro that runs OutpuTo a txt file.

On the exported file, can I automatically rename the file with this naming
convention: "mmddyy or (now)" & "query name".txt = 040808Sales.txt

Thank you.

 

[Steve Schapel]

Brig,

No problem about putting in the date. Just set the Output File argument
of the OutputTo action to:
="C:\YourFolder\" & Format(Date(),"mmddyy") & "Sales.txt"

However, I know of no way to use a variable name of the query in this
way. (Unless you are using Access 2007, in which case it may be
possible to use a SetTempVar action to achieve this.)

 

[Brig]

Thank you very much.

--
Brig

Brig,

No problem about putting in the date. Just set the Output File argument
of the OutputTo action to:
="C:\YourFolder\" & Format(Date(),"mmddyy") & "Sales.txt"

However, I know of no way to use a variable name of the query in this way.
(Unless you are using Access 2007, in which case it may be possible to use
a SetTempVar action to achieve this.)

 

[CL]

Thanks you so much, this really helped me!

Brig,

No problem about putting in the date. Just set the Output File argument
of the OutputTo action to:
="C:\YourFolder\" & Format(Date(),"mmddyy") & "Sales.txt"

However, I know of no way to use a variable name of the query in this
way. (Unless you are using Access 2007, in which case it may be
possible to use a SetTempVar action to achieve this.)