Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 1 of 1
Thread: Excel Consolidation with an App
08-20-2008, 04:14 PM #1
- Join Date
- Aug 2008
- Thanked 0 Times in 0 Posts
Excel Consolidation with an App
Basically I need to read certain cell values out of a batch of excel files in a certain directory, and write to another excel file. For example add up all values from B3 in a directory of files and write to another one.
Is there a nice API to do this, or can excel do this already, or is there something out there that can do this.
The files will be changed once a week, and once a week i wanted to be able to run this and create a new file from it.
Any ideas on how to attack this would be great.
Thanks in advance.