Opening multiple files (csv), applying a macro and save it in separate xls

[Masi Zeyb]

Hello,
[I put this before but it goes to pg15, and still no reply]
I'm new in VBA, and I have tried for several days to tackle with my problem by searching in internet, but now it seems I need the professionals help ...

There are more than 100 excel files (*.csv) in different folders. Each excel file contains:

1. 3 columns [A-Date, B-hour (unnecessary), C-Value],
2. 1st row is description line,
3. and 2nd row is col. header (data should be read from 3rd row)

​
Data is stored daily for several years. What I want to do is make it monthly for each year.

Open the excel file. "Sheet1" is renamed.
Change format of 1st col. (A-Date) to DMY.
Calculate summation for each month. (summation of values in col.C)
Write the results in another excel file in following format...

Please refer to the image and sample CSV.

[Naveed Raza]

u want the output after summarizing the data right.

one more thing each folder contain how many csv files..... and in which format u want to save the output workbook....

[Masi Zeyb]

Right, the results need to be saved in a separate xls. file.
The number of files in the folders are not fixed. But, name of the files are 6 digits number.
Tq for your reply

[Naveed Raza]

i will get back to today EOD is it ok for u....?

[Masi Zeyb]

ok, no problem, i thought there is no solution man !

[Naveed Raza]

Sorry for Late reply Masi,

I almost done your query don't worry very soon u will get your solution file.

from last 2 days i am working on your query but i am facing some problem with your attached CSV File.

When i am copying your data and pasting in Excel files the date format getting change and i am not getting exact count.

[tony h]

did you get an answer to this? As a matter of interest what is the data you are analysing?