VBA saving in Text (tab-delimited) format 
Author Message
 VBA saving in Text (tab-delimited) format

From File->Save As... you can choose the
file: Text (tab-delimited).
From the list available to me in VBA I
don't see this option. (for the heck of
it, I tried xlTabDelimited and all the
variations I could think of).

This is what I want to do:
Activebook.SaveAs Filename:="whatever",
FileFormat:=xlTabDelimited

Any ideas?

Thanks in advance!
--Seth



Wed, 18 Jun 1902 08:00:00 GMT  
 VBA saving in Text (tab-delimited) format

Best solution I've seen yet:
http://www.cpearson.com/excel/imptext.htm
Make your own export.

--Seth

Quote:

> From File->Save As... you can choose the
> file: Text (tab-delimited).
> From the list available to me in VBA I
> don't see this option. (for the heck of
> it, I tried xlTabDelimited and all the
> variations I could think of).

> This is what I want to do:
> Activebook.SaveAs Filename:="whatever",
> FileFormat:=xlTabDelimited

> Any ideas?

> Thanks in advance!
> --Seth



Wed, 18 Jun 1902 08:00:00 GMT  
 VBA saving in Text (tab-delimited) format

Using the macro recorder, I recorded the following code:

ActiveWorkbook.SaveAs filename:= _
   "C:\Test.txt", _
   FileFormat:=xlText, _
   CreateBackup:=False


Quote:
> From File->Save As... you can choose the
> file: Text (tab-delimited).
> From the list available to me in VBA I
> don't see this option. (for the heck of
> it, I tried xlTabDelimited and all the
> variations I could think of).

> This is what I want to do:
> Activebook.SaveAs Filename:="whatever",
> FileFormat:=xlTabDelimited

> Any ideas?

> Thanks in advance!
> --Seth



Wed, 18 Jun 1902 08:00:00 GMT  
 VBA saving in Text (tab-delimited) format
Seth,

Instead of tab-separated values, why don't you choose one of the comma-
separated value formats?  According to Help (FileFormat Property), you
have the following formats to choose from:

xlCSV
xlCSVMac
xlCSVMSDOS
xlCSVWindows

Too bad SaveAs Method doesn't appear to offer you the ability to select
the separator character, as you can when using the text to columns
wizard on importing a file.

Ron

Quote:

> Date: Mon, 06 Nov 2000 13:56:53 -0500

> Subject: VBA saving in Text (tab-delimited) format
> Newsgroups: microsoft.public.excel.programming

> From File->Save As... you can choose the
> file: Text (tab-delimited).
> From the list available to me in VBA I
> don't see this option. (for the heck of
> it, I tried xlTabDelimited and all the
> variations I could think of).

> This is what I want to do:
> Activebook.SaveAs Filename:="whatever",
> FileFormat:=xlTabDelimited

> Any ideas?

> Thanks in advance!
> --Seth



Wed, 18 Jun 1902 08:00:00 GMT  
 VBA saving in Text (tab-delimited) format
Thanks Jeff!

Using the macro recorder you found the undocumented (in the
help files anyway) way to save tab-delim files. :) I will use
the macro recorder more often, now.

Regards,
--Seth

Jeff McAhren wrote in part:

Quote:
> Using the macro recorder, I recorded the following code:

> ActiveWorkbook.SaveAs filename:= _
>    "C:\Test.txt", _
>    FileFormat:=xlText, _
>    CreateBackup:=False



Wed, 18 Jun 1902 08:00:00 GMT  
 
 [ 5 post ] 

 Relevant Pages 

1. Save As Tab Delimited gives space Space Delimited ???

2. save to txt pipe delimited not tab delimited

3. writing tab delimited text files using vba

4. Saving - Text (Tab delimited)

5. Automating save as tab delimited text

6. Save As Non-Tab Delimited Text

7. Save as tab delimited text

8. Save as tab delimited text?

9. Saving cells as tab delimited text

10. Problems saving .xls as .txt (Text Tab Delimited)


 
Powered by phpBB® Forum Software © phpBB Group