+ Reply to Thread
Results 1 to 2 of 2

Want to create a text file from an excel file which has format spec using macro. pls help!

  1. #1
    Registered User
    Join Date
    12-09-2014
    Location
    Chennai
    MS-Off Ver
    Excel 2010
    Posts
    1

    Want to create a text file from an excel file which has format spec using macro. pls help!

    Hi All,

    I want to create a text or csv file based on a excel file which is having the format spec. Attched the excel file and sample input file.

    And also I want to update the field value in text or csv file for any of the fields during runtime.


    Please help!!!

  2. #2
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Want to create a text file from an excel file which has format spec using macro. pls h

    You haven't attached any example of what you're trying to achieve.

    Have a read of my blog post here, describing one method of writing data to text files: http://excel.solutions/2014/04/using...-to-text-file/
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

+ 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. [SOLVED] Macro to create text file and write contents of selected cells to the file
    By m@cro in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-13-2013, 10:21 AM
  2. need macro to create pipe delimited text file from excel
    By nefkho in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-04-2012, 12:03 PM
  3. Replies: 3
    Last Post: 09-30-2011, 04:35 AM
  4. transfer excel file to text file format
    By tllcll in forum Excel General
    Replies: 1
    Last Post: 07-17-2006, 07:55 AM
  5. [SOLVED] excel - create a macro to use cell text as part of a file name
    By bossman tv in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 06-27-2006, 05:40 PM

Tags for this Thread

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