Hex92
01-05-2004, 11:52 AM
I have to generate reports for work in Excel format to be sent on to a state agency. The way I have it set up I have to run a query for each sample (our lab analyzes environmental samples for pollutants) in Access and export it into excel. The I run a macro in excel on the output to make it look nice and then I have to combine the final results into 10 samples (worksheets) to be sent off.
This gets quite tedious when generating 30-100 reports at a time. I have to export results>input file name>input sample name>open in excel>run format macro for each sample.
At the very least I would like to be able to generate the reports 10 at a time. The catch is that they each have to be on their own sheet in excel. That way I could open the files just run the macro on each sheet. The other catch is that each sample can contain anywhere from 5-150+ hits so the cutoff point between them can't be set to an arbitrary number.
IS this possible?
:confused:
This gets quite tedious when generating 30-100 reports at a time. I have to export results>input file name>input sample name>open in excel>run format macro for each sample.
At the very least I would like to be able to generate the reports 10 at a time. The catch is that they each have to be on their own sheet in excel. That way I could open the files just run the macro on each sheet. The other catch is that each sample can contain anywhere from 5-150+ hits so the cutoff point between them can't be set to an arbitrary number.
IS this possible?
:confused: