+ Reply to Thread
Results 1 to 4 of 4

Comma to appear after last value, file starts as xlsx, saved as csv, opened in notepad

  1. #1
    Registered User
    Join Date
    05-15-2014
    MS-Off Ver
    Excel 2003
    Posts
    31

    Comma to appear after last value, file starts as xlsx, saved as csv, opened in notepad

    Hello,

    I am creating an upload template to our system. The file starts out as a xlsx, then it is saved as a csv, and opened in notepad. I need the last values of each cell to have a comma appear when it is saved as csv and then opened in notepad. I would appreciate it if there was not a macro created for this. I have attached an excel file that depicts what I need. Thank you for your help!
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor ranman256's Avatar
    Join Date
    07-29-2012
    Location
    Kentucky
    MS-Off Ver
    Excel 2003
    Posts
    1,176

    Re: Comma to appear after last value, file starts as xlsx, saved as csv, opened in notepad

    The comma CANNOT appear after the last field because that denotes the END OF RECORD.

    Now, you can run a macro that
    exports the CSV file
    then opens the csv file and adds the comma to the end.
    done.
    Macros are our friends.

  3. #3
    Registered User
    Join Date
    05-15-2014
    MS-Off Ver
    Excel 2003
    Posts
    31

    Re: Comma to appear after last value, file starts as xlsx, saved as csv, opened in notepad

    I would love to run a macro, but this template is going to used throughout the company and not every one is very macro friendly. There is absolutely no way to have it show up without a macro?

  4. #4
    Valued Forum Contributor ranman256's Avatar
    Join Date
    07-29-2012
    Location
    Kentucky
    MS-Off Ver
    Excel 2003
    Posts
    1,176

    Re: Comma to appear after last value, file starts as xlsx, saved as csv, opened in notepad

    Put it in your PERSONAL macro book.

+ 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. Replies: 6
    Last Post: 10-04-2013, 08:11 AM
  2. .txt files (delimiter: comma) into .xls or .xlsx file
    By Pradeep M B in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-01-2013, 09:57 AM
  3. How to save the opened word document as a Notepad/text file?
    By Rahul888 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-10-2012, 05:38 PM
  4. Paste into opened notepad file
    By oOpsy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-02-2005, 09:00 AM
  5. [SOLVED] Determine if XL file opened from Outlook or a saved file
    By quartz in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-16-2005, 05:05 PM

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