HI
Dynamic graph a chart from multiple files and save them to the new files ?
I am a newbie to VBA, I hope that someone here can help me with the VBA excel to dynamic generate chart from multiple files
what my expectation is,
1. click to open select folder where the files located
2. automatically open those files and pickup datas from column A,B,C and generate a a line graph(with maker style prefered),
3. then save the graph with same file name, but to a different folder by clicking selelct a different folder for files to be saved
Here the data in csv files, every files contain pretty much the same thing, I want the code to automatically pickup the data from column A, B, C and chart it and save it to different or the same file name
A5(date), B5(time), C5(temperature)
3/2/2012 9:07:57 0
3/2/2012 9:15:00 3.78
3/2/2012 9:30:00 3.84
3/2/2012 9:45:00 3.78
3/2/2012 10:00:00 3.72
3/2/2012 10:15:00 3.81
3/2/2012 10:30:00 3.78
3/2/2012 10:45:00 3.69
3/2/2012 11:00:00 3.72
3/2/2012 11:15:00 3.75
3/2/2012 11:30:00 3.69
3/2/2012 11:45:00 3.78
3/2/2012 12:00:00 3.72
3/2/2012 12:15:00 3.69
3/2/2012 12:30:00 3.75
3/2/2012 12:45:00 3.75
3/2/2012 13:00:00 3.63
3/2/2012 13:15:00 3.69
3/2/2012 13:30:00 3.75
3/2/2012 13:45:00 3.66
3/2/2012 14:00:00 3.81
3/2/2012 14:15:00 3.88
3/2/2012 14:30:00 3.75
Please help me :'(
thanks, I appreciate it!
Best
Kwizard
Bookmarks