View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
stevieb stevieb is offline
external usenet poster
 
Posts: 16
Default SaveAs *.txt - Outputting with Text quantifiers

Hello,

I am trying to export a worksheet as a *.txt file but do not want the text
quantifiers to appear (ie. the quotations around the text columns).

Here is a snippet of my saveas code:
ActiveWorkbook.SaveAs Filename:=mylocation , _
FileFormat:=xlText, CreateBackup:=False

Do I either have to change the format of the columns before I use the SaveAs
or can I mod the SaveAs function (ie. use a different paramter or try
different FileFormat's.)

Thanks,
-Steve