+ Reply to Thread
Results 1 to 4 of 4

Read Excel line and write it on a text file with other extension and with specific layout

  1. #1
    Forum Contributor
    Join Date
    05-09-2013
    Location
    london
    MS-Off Ver
    Excel 2016
    Posts
    107

    Read Excel line and write it on a text file with other extension and with specific layout

    Dear all,

    I have this kind of data on a Excel file. The data starts on A1 cell, and B1 cell:
    Please Login or Register  to view this content.
    I would like a VBA code that could read each line of the Excel, and write it in a specific layout to a xxxx.silo5 file. For example, on this sample the VBA code should write a .silo5 file on this layout:
    Please Login or Register  to view this content.
    As you can see, the data format has been inverted (original was dd-mm-yyyy and final is yyyy-mm-dd), and after the date it writes the number of Excel line for each line (as you can see the first line has a "1", second a "2", third a "3" and so on...

    Can someone give me some help over here?

    PS - The comma in the value of the number is my decimal separator!

    Thank you!
    Last edited by ropbasuel; 04-12-2016 at 11:53 AM.

  2. #2
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,907

    Re: Read Excel line and write it on a text file with other extension and with specific lay

    Try this one.
    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    05-09-2013
    Location
    london
    MS-Off Ver
    Excel 2016
    Posts
    107

    Re: Read Excel line and write it on a text file with other extension and with specific lay

    Quote Originally Posted by bakerman2 View Post
    Try this one.
    Please Login or Register  to view this content.
    Dear bakerman2,

    What a funtastic work!!!!! It works like a charm!!! Thank you so so much for this!

    I will give you reputation and mark this thread as solved!!!

    Really thanks for your time and knowledge!!

    Regards

  4. #4
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,907

    Re: Read Excel line and write it on a text file with other extension and with specific lay

    Now that's a quick reply.
    Thanks so much for your kind words and reps
    Always glad to help.

+ 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] VBA excel read random line from text file
    By VBAxxx in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-14-2017, 04:15 AM
  2. Macro to copy specific line from text file and paste into specific cell in excel
    By keeneye in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-05-2013, 10:35 AM
  3. Read value from certain line in text file
    By steamu in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-16-2012, 10:33 AM
  4. Skip The Read Only Prompt When I Open A File - Excel, Open it read-write instead.
    By harry_1805 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-06-2012, 02:14 AM
  5. [SOLVED] Read whole file,Match the headers based on specific condition & write to text file
    By macromaniac in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 06-07-2011, 06:37 AM
  6. To read many text files and write it in the excel file
    By nynamyna in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 12-16-2009, 01:51 PM
  7. Read and Write Excel file
    By Robot in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-03-2005, 10:05 AM
  8. How to read & write Ini File to Excel
    By lehainam in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-23-2005, 10:39 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