Create Tab delimited file with no quotes in Currency fields.

A

AP

Hello! I'm trying to create a tab delimited file; but with no "double
qualifiers" using SaveAs. The field must be in a currency format, so I can't
change the format. If the total have commas it will create "" automatically.
This is what I have so far; I know there are other options to create this
file; but how without "quotes"??

Here's what i have so far:

Private Sub CmdTest_Click()

Columns("A:H").Select
ChDir "C:\test"
ActiveWorkbook.SaveAs Filename:= _
"C:\test\test_" & Format(date, "yyyymmdd") & ".txt" _
, FileFormat:=xlText, CreateBackup:=False

End Sub

I will appriciate any help!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top