Creating a comma delimited text file from an excel workbook
Posted on 2004-04-06
I am trying to create a report in excel from SQL server. This part of the problem works just fine, however the end result needs to be in the form of a comma delimited text file... and the excel text file it creates is not visible in notepad.
How might I get this to work?
the command button code to create the txt is below
Private Sub CommandButton2_Click()
Dim filenme As String
Application.CutCopyMode = False
filenme = InputBox(Prompt:="Please enter report date (ie 04022004)", Title:="Save As...")
'If filenme = "" Then Exit Sub
ActiveWorkbook.SaveAs Filename:="F:\groups\creDIT\nacm reports\nacm" + filenme + ".txt", FileFormat:= _