VBA saving in Text (tab-delimited) format
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:
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.
> 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",
> Any ideas?
> Thanks in advance!