Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi all,
I'm new to the world of excel programming. Please help me, as this problem bothers me for quite a long time. I have many .csv files (generated by programmes), all I want to do is comparing those files and do some analysis (eg. charting). How can I automate the whole process? Eg. I have to .csv files. A.csv and B.csv (they can be as simple as a name and a value to compare, eg. SALARY, 60). How can I: 1. create a AB.xls file contain these two worksheets 2. plot a chart for comparison in a new worksheet in the same AB.xls file. (eg. BAR chart to compare SALARY of A & B) How can they be achived (programs, scripts, etc) by not manually?! Thanks!!! |