Export snp file from access - file name

Hi,

I would appreciate help with a problem. I have the following function, which exports a .snp file (kl.snp) from access:

Function Makro_max()
DoCmd.OutputTo acReport, "rptdob_KlVlastni_IMT_Max", "SouboryveformátuSNP(*.snp)", "C:\Documents and Settings\kvit\Karel\Komentare\Test\KLnaSQL\Export\kl.snp", False, "", 0

End Function

What do I do if I want to export this file let's say daily, where the name of each file should vary every day containing information of current date, e.g. "070903.snp" instead of kl. snp. How do I do that in a VBA code?

Tahank you.

Ezop

[826 byte] By [ezop] at [2008-1-9]