B
Brent
I think I posted this to the wrong news group today so if you view both of
these groups I apologize in advance. If there is something I'm saying that
I need to explain differently please let me know.
I have an issue that is probably fairly easy to accomplish but I just don't
know how to do it. I have a query that pulls all of the work orders that
are open . I would like to take this query and have it export it
automatically to excel. Here is the catch. I need to have this run and
create a separate excel sheet for each of the crews identified by CrewID
field and name it with the
CrewID and today's Date. I have read how to do the naming in other news
post but am not good enough to write the code to loop through each crew
and create the files dynamically. Any ideas on code to do this?
Thanks for taking the time to look at this.
Brent
these groups I apologize in advance. If there is something I'm saying that
I need to explain differently please let me know.
I have an issue that is probably fairly easy to accomplish but I just don't
know how to do it. I have a query that pulls all of the work orders that
are open . I would like to take this query and have it export it
automatically to excel. Here is the catch. I need to have this run and
create a separate excel sheet for each of the crews identified by CrewID
field and name it with the
CrewID and today's Date. I have read how to do the naming in other news
post but am not good enough to write the code to loop through each crew
and create the files dynamically. Any ideas on code to do this?
Thanks for taking the time to look at this.
Brent