C
cooper
Hello,
I would like to create a macro in Access 2002 (xp) that outputs 3
queries to excel for each of my 50 projects. the project names change nearly
every month as do the number of fields in the queries for each project (the
output is based on crosstab queries). I can get this to work manually.
what is need is an automatic way so the reports can be generated first
thing every morning, naturally each of the output files will need to have
their project code in their name.
what is have:
crosstab queries that will work
a master list of all projects (some projects are not worked each
month so in the months they are not worked I would not want output files
crated for them)
the purpose you ask... I then take my 3 excel files and run a macro on
them to combine then into one spreadsheet that the managers promptly ignore.
(I would love this to occur for each of the project automatically as well,
but this is the wrong place to ask)
Thank you in advance.
I would like to create a macro in Access 2002 (xp) that outputs 3
queries to excel for each of my 50 projects. the project names change nearly
every month as do the number of fields in the queries for each project (the
output is based on crosstab queries). I can get this to work manually.
what is need is an automatic way so the reports can be generated first
thing every morning, naturally each of the output files will need to have
their project code in their name.
what is have:
crosstab queries that will work
a master list of all projects (some projects are not worked each
month so in the months they are not worked I would not want output files
crated for them)
the purpose you ask... I then take my 3 excel files and run a macro on
them to combine then into one spreadsheet that the managers promptly ignore.
(I would love this to occur for each of the project automatically as well,
but this is the wrong place to ask)
Thank you in advance.