Hi,

I'm in the middle of designing a piece/pieces of code to help simplify my life at work. I've done some VBA coding in the past and that is relevant to this concept. Basically, I'm refreshing reports one at a time through running a sql statment populating a recordset and then passing the results as parameters to refresh a report and then the report gets saved in a filename structure based on the parameters passed. This report gets refreshed many many times and it takes about 2 - 3 mins per refresh. All of this code is done using VBA.
I have access to a couple other remote machines to which I could pass these variables to as well and cut the total time to refresh all reports down considerably. So where I need guidance is in the understanding of what/how to interface the main portion of my code above that contains the record set and these remote machines that will somehow receive the variables passed to them. Through some initial reading I think I need to use COM to get this done, but not exactly sure. My concept involves passing parameters to these remote machines and when the first machine becomes available it will request to have another set of variables passed to it until the record set is completed. So in total maybe 15 machines refreshing reports at a time. I understand I will obviously not be using VBA, but more likely just VB and just refrencing the object model of the application. So for the main piece of code that generates the record set and passes the parameters would be one piece of code the other would be a piece that sits on each remote machine that accepts these parameters refreshes the reports, saves and then asks for another set of parametes from the main piece of code.
Can anyone help with understanding how I will pass these parameters to remote machines, and if COM is the best/easiest way to accomplish this.
Thanks in advance.
Joel