PC Review


Reply
Thread Tools Rate Thread

Create Tab delimited file with no quotes in Currency fields.

 
 
AP
Guest
Posts: n/a
 
      5th May 2010
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!

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Double quotes when exporting to tab delimited file jjk98 Microsoft Excel Misc 2 13th Jan 2010 01:53 PM
Re: Output space-delimited file with quotes around text? Gord Dibben Microsoft Excel Misc 0 5th Dec 2006 11:02 PM
ADO choking on quotes inside a pipe delimited text file Masa Ito Microsoft VB .NET 0 31st May 2006 02:21 PM
Import Pipe Delimited File, Parse out certian Fields, create new f =?Utf-8?B?U3RhckJveTIwMDA=?= Microsoft Excel New Users 4 17th Jul 2005 07:36 AM
Save As Tab Delimited File Adds Quotes Mary Beth Microsoft Excel Misc 1 8th Oct 2003 02:28 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:30 PM.