+ Reply to Thread
Results 1 to 8 of 8

Excel Macro to create Header and lines and save with Pipe CSV format

Hybrid View

  1. 11-02-2018, 11:03 PM #1
    karedog
    karedog is offline
    Forum Guru karedog's Avatar
    Join Date
    10-03-2014
    Location
    Indonesia
    MS-Off Ver
    2003
    Posts
    2,971

    Re: Excel Macro to create Header and lines and save with Pipe CSV format

    Thanks for rep.points. Just add the code line in red below :
        d = .Range("B1:B3").Value
    d(1, 1) = Format$(d(1, 1), "YYYYMMDD")
    a = .Range("A5").CurrentRegion.Value
    1. I care dog
    2. I am a loop maniac
    3. Forum rules link : Click here
    3.33. Don't forget to mark the thread as solved, this is important
    Reply With QuoteRegister To Reply
  2. 11-04-2018, 11:01 PM #2
    spr2017
    spr2017 is offline
    Registered User
    Join Date
    11-21-2017
    Location
    SYDNEY
    MS-Off Ver
    2016
    Posts
    36

    Re: Excel Macro to create Header and lines and save with Pipe CSV format

    Perfect thanks heaps
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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 txt-file with pipe seperator
    By elgato74 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-27-2017, 09:22 AM
  2. 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
  3. Macro to open multiple files, remove header and save multiple files in a new format
    By twocircles in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-17-2014, 05:24 PM
  4. Combine Excel Sheets (+2 Million Rows total) and Create Pipe Delimited TEXT File
    By kestefon in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-05-2013, 08:51 PM
  5. 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
  6. How to save an excel in a pipe delimited format?
    By princesouvik in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-08-2009, 03:13 AM
  7. How can I save Excel am spreadsheet as pipe delimiter?
    By Sarah in forum Excel General
    Replies: 5
    Last Post: 05-25-2006, 03:40 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1