+ Reply to Thread
Results 1 to 4 of 4

Save Column as TXT file with .NC Extension

  1. #1
    Forum Contributor
    Join Date
    11-28-2005
    Location
    Dover, England
    Posts
    172

    Save Column as TXT file with .NC Extension

    I have managed to extract all the data I require from within my workbook and put it into column A of a Worksheet called "combined". I am looking to save that worksheet, as named, to a directory (e.g."c:\temp") but with an .NC extension. If a copy exists within the directory it needs to be overwritten.


    Thanks

  2. #2
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967

    Re: Save Column as TXT file with .NC Extension

    Put double quotes around the desired filename when saving and the .xlsx extension will not be automatically added.

    Alternatively just rename in Windows Explorer
    Martin

  3. #3
    Forum Contributor
    Join Date
    11-28-2005
    Location
    Dover, England
    Posts
    172

    Re: Save Column as TXT file with .NC Extension

    This is what I currently do, but I am looking to automate this by the pressing of a button. There is monitoring software that picks up the file and uses the data within.

  4. #4
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967

    Re: Save Column as TXT file with .NC Extension

    Try

    Please Login or Register  to view this content.

+ 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. How to save file with correct file extension, .xls or .xlsx?
    By Alexb77 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-12-2014, 12:52 PM
  2. How To Save Macro File Not Using .XLSM Extension
    By crouching_tiger in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-24-2014, 07:37 AM
  3. Replies: 1
    Last Post: 01-23-2012, 03:16 AM
  4. How can I save a file in Excel 2007 beta 2 as a .dbf extension?
    By Darren Crewes in forum Excel General
    Replies: 1
    Last Post: 06-03-2006, 06:35 PM
  5. [SOLVED] Additional file with no extension created during File Save As proc
    By Peter Rooney in forum Excel General
    Replies: 2
    Last Post: 08-11-2005, 10:05 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