Macro for output to existing result files

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

Sam - I suggest you attach a small sample workbook illustrating how your data are laid out and how you would like the output laid out.

Welcome to the forum!

One method might be to build an xls with minimal data with the charts and macros already created. The code would copy this "template" file and insert the data. One method that would work well is ADO. You can use SQL to Insert data Into the table without ever opening the copied xls. Of course it is easy enough to Open the copied xls and insert the data from another xls or your personal.xls's code.

Thanks Stephen and Kenneth - i am very grateful for your help,

Unfortuantely Kenneth I don't understand some of the technical terms you have used or how to implement what you have suggested!

I have attached some toy files which hopefully illustrate

1) The layout of the data i am producing ("Optimisation program outputs")
2) The layout of the output files that needs to be produced - i have included an example of some basic post processing which will need to be done ("Output file template")

I have also attached a schematic diagram which may help to illustrate my problem more clearly.

Thanks,

Sam Gregson