Hi all,

I hope you can help me.

I have a problem in Excel 2007. I am currently running an optimisation program for a fuel cell.

The optimisation program considers 5 minute electrical demand data for a whole year and has over 105,000 rows of data on the main calculation page - it is very large.

To produce useful outputs, the program must be run over and over with different input parameters (to help optimise the operation of the FC) - i can handle this programing. However, with the program being so large, I would like to output the results of each program run to a seperate output file (this helps to keep down the size of the initial program file - this presents me with several problems:

1) How do I select my output columns/range (in the original program) and output to a different output file?

2) When the outputs arrive in the output files, I need to do a lot of post processing (to produce the required graphs/tables). As such, the output files to which the outputs are written must already exist and contain all necessary post processing formulae and formatting.

3) When I send the program to the client, won't the output file locations be lost and the output macro rendered useless???

I am really struggling to think how best to procede- if anyone has any hints/ideas they would be very gratefully received.

Thanks,

Sam