Exporting to a txt file without surrounding quotes

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

I execute the following code. It generates a file called
Report.txt. The resulting file contains the desired
string surrounded by quotes. I would like to eliminate
the quotes surrounding this text. Any suggestions?
Thanks in advance,
Dave

strReport = "ABCD 0012345" & Format(Date(), "mm/dd/yyyy")
SourceFile = "C:\Temp\Report.txt"
On Error Resume Next
Kill SourceFile
FileNumber = FreeFile
Open SourceFile For Output As #FileNumber
Write #FileNumber, strReport
Close #FileNumber
 
Back
Top