Hello,
I am new to excel or vba
i want to convert a data to export it to some output folder from a csv files from input folder
there are 100's of such file in c:\raw which i want to work with
the input file's details are
the headers of the file are as given below
20081025.100524,15.85,100
the name of the file is say xyz.csv
the first column is date&time merged into one col sperated with . (dot)
the 2nd col is price
the 3rd col is volme
The output i want is should as:
symbol ( from filename)
date (to be seperated from the date.time which is to be splitted )
time
price
volume
i have made part of the excel with macro with 2 bottons
It reads all the files in c\raw and lists me
after i press process file button it should do the above work on each file
can anyone Please give me a macro do it