CSV to XLSX file convertion

[maxterrr]

Hi All,

I need a help for the below convertion and it will be a great help if some one can help me over the below convertion.

The input file is a .CSV file (first file) and it needs to be converted in to a .XLSX file (second file) in the show below format (jpg, csv and xlsx files attached), data from .CSV file needs to be taken and put in to the second file in a way that it looks exactly like the .XLSX file.

1) The data in first file (.CSV) will change time to time and depending on that data the second file (.XLSX) should reflect the correct information
2) The event codes will vary every time so the data should be dynamically generated in the second file very time we run the macro
3) Event time column (in the second file) should display the date and time in the shown format only (Sep 14 2017 10:56 PM)
4) The data in event column should be displayed separately for separate events


Many Thanks
Santanu

[jindon]

This will output the result in Activesheet, so be careful since it deletes all the cells first.

Please Login or Register  to view this content.

[maxterrr]

Hi Jindon,

Thanks for the help, i also have few queries with respect to the output file

The row 2, 3 and 4 should be in row 1 along with row 1 data
and row 5 should be in row 2

also can you make the query work for all kindly of files names starting with anything not necessary PROD_DDS, it can be any file name example abc.csv or anything

Regards

[jindon]

I wrote the code exactly according to your output, so I don't understand what you are talking about.

If you are opening other csv file than the one posted in your first post, you should upload the file.

[maxterrr]

Thanks for the reply, If i run the script i see the output file (left side of the snapshot, also attached) the data on row 2, 3 and 4 should appear in row 1 (just like shown in the snapshot to the right) and row 5 data (refer snapshot to the left) should appear on row 2 (snapshot to the right) which is not happening

The final output should look like the snapshot at the right

attached is the output file which i am getting after running the below script, many thanks

[jindon]

It should produce exactly the same as your result.

[maxterrr]

Thanks a lot, will close this once i get a chance to confirm the same.