OutputTo File Naming Convention

  • Thread starter Thread starter Brig
  • Start date Start date
B

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.
 
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.)
 
Thank you very much.

--
Brig

Steve Schapel said:
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.)
Click to expand...
 
Thanks you so much, this really helped me!

Steve Schapel said:
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.)
Click to expand...
 
Back
Top