I have to create some files (exported from MSaccess tables). The files are creating and exporting just as I like, except for one thing.
I need to add a '.' (dot) into the file name. I realise that this is really bad naming practice, but this is how the files need to be named in order for some other software to find them. an example of a name would be 27.09pri_front.txt.
When I try and add the dot, the files are still created, but the dot has been substitued by a hash (#).
Am I trying to do the impossible? If so, please can someone let me know? If not, any advice would be very grateful.
Here is the part of the code that creates the output file. I am using MSAccess 2002.
Many thanks!
I need to add a '.' (dot) into the file name. I realise that this is really bad naming practice, but this is how the files need to be named in order for some other software to find them. an example of a name would be 27.09pri_front.txt.
When I try and add the dot, the files are still created, but the dot has been substitued by a hash (#).
Am I trying to do the impossible? If so, please can someone let me know? If not, any advice would be very grateful.
Here is the part of the code that creates the output file. I am using MSAccess 2002.
Many thanks!
Code:
'Here the original filename is set eg: 29.09
Orig_file = Forms![Switchboard]![Original]
'Does reworkfolder exist?
folderpath = reworkfolder
If fso.FolderExists(folderpath) Then
'MsgBox "folder Exists"
Else
MkDir reworkfolder
End If
DoCmd.TransferText acExportDelim, "Rework_Back Export Specification", "rework_back", reworkfolder & "\" & Orig_file & "back_REM.txt", True
DoCmd.TransferText acExportDelim, "Rework_Front Export Specification", "rework_front", reworkfolder & "\" & Orig_file & "front_REM.txt", True