Dear all,
I have this kind of data on a Excel file. The data starts on A1 cell, and B1 cell:
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:
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!
Bookmarks