embed period in text

[Maury Readinger]

I am using vba to name a file for export. I set the file name up as filename.S & today's date.
The code works fine but the file is exported as filename#S. How do I set up the code to keep the period?
Ex.
str_FileName = "MMR.S" & Temp

DoCmd.TransferText acExportFixed, "MMR Export Specification", "Temp_MMRtext_Table", ThisFileName, False

 

[skiphooper]

Maury,
I think the problem is that you are trying to create a file with an extension of
.s02062001
Most operating systems usually use an extension of of 3 characters.

try str_filename = "MMR" & temp & ".s"
MMR02062001.s
I dont think "/" is accepted in extensions.

Skip

PS:If I'm wrong, someone please let me know.

 

[Maury Readinger]

Skip,
I'm trying to create a filename
ex. Maury.S021401.xls
The code seems to work, but when I go into Windows explorer, the filename is:
Maury#S021401.xls.
Maybe you're right. Maybe I can only have
one file extension.
I'll try it.