+ Reply to Thread
Results 1 to 5 of 5

Macro to save sheet as tab delimited file.

  1. #1
    Registered User
    Join Date
    08-18-2015
    Location
    Birmimgham
    MS-Off Ver
    2015
    Posts
    78

    Macro to save sheet as tab delimited file.

    I have several sheets in my workbook. I would like to create VB code to save a sheet (Sheet-Qty) as a tab delimited file. I would like it to overwrite the file without asking and to provide a message box to say it was saved successfully. I have found the below code. Can someone please help me edit it? Thanks


    Please Login or Register  to view this content.
    Last edited by San75; 01-04-2016 at 09:03 AM. Reason: code tags added

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: Macro to save sheet as tab delimited file.

    Code Tags Added
    Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

    Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

    Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



    ( I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    08-18-2015
    Location
    Birmimgham
    MS-Off Ver
    2015
    Posts
    78

    Re: Macro to save sheet as tab delimited file.

    Is the correct for saving a sheet called qty as a TAB delimited file?

    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    08-18-2015
    Location
    Birmimgham
    MS-Off Ver
    2015
    Posts
    78

    Re: Macro to save sheet as tab delimited file.

    or should it be Sheets("qty").Saveas Filename:="C:\qty.txt", FileFormat:=xlTabDelimited

  5. #5
    Registered User
    Join Date
    08-18-2015
    Location
    Birmimgham
    MS-Off Ver
    2015
    Posts
    78

    Re: Macro to save sheet as tab delimited file.

    Can someone help please?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Script/macro to save a copy as tab delimited text file and then close original file
    By Merlin803 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-02-2015, 01:34 PM
  2. [SOLVED] Macro to save file as CSV (Comma Delimited)
    By Jiptastic in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-09-2014, 03:23 PM
  3. VBA to Save a Single Sheet as a Tab Delimited Text File
    By mattmc419 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-05-2014, 03:34 PM
  4. [SOLVED] Macro to Save Excel sheet as comma delimited txt file
    By dileeprajam in forum Excel Programming / VBA / Macros
    Replies: 22
    Last Post: 04-22-2014, 05:01 PM
  5. Macro needed to save file in pipe delimited format
    By Blaked86 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-04-2014, 09:04 AM
  6. Replies: 1
    Last Post: 05-03-2005, 06:06 PM
  7. [SOLVED] save excel file from a table delimited file (.txt) using macros
    By sedamfo in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 02-15-2005, 01:06 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1