Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Posts
    3

    Question Unanswered: Saving in Tab Delimited

    How would you save an Excel worksheet as a Tab Delimited file using VBA?

    Thanks

  2. #2
    Join Date
    Oct 2003
    Posts
    1,091
    One line:

    Code:
    ActiveWorkbook.SaveAs Filename:= _
            "C:\Documents and Settings\...\~~Working Folder\Book1.txt", _
            FileFormat:=xlText, CreateBackup:=False
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  3. #3
    Join Date
    Oct 2003
    Posts
    1,091
    Keep in mind that .txt files can only have one sheet (not the multiple ones in Excel).
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •