PRO Needed for urgent help

R

rivers

I have a Database which to save time training management levels how to use i
have created an excel analysis pack which is sent to everyone, i have 3
queries which i just open manually and copy and paste into the excel file
named "review.xls".
The Queries are called "rev1", "rev2","rev3", each query goes to the
required worksheet i.e rev1 goes to worksheet "rev1 import" what i want is
for the ability in access to create a macro to open and paste these records
automatically without me having to do this copy paste process everyday. i
have tried the excel data import but the nz function is utilised in these
queries and Excel does not find the queries.

can anyone help

thanks in advance
 
J

John W. Vinson

I have a Database which to save time training management levels how to use i
have created an excel analysis pack which is sent to everyone, i have 3
queries which i just open manually and copy and paste into the excel file
named "review.xls".
The Queries are called "rev1", "rev2","rev3", each query goes to the
required worksheet i.e rev1 goes to worksheet "rev1 import" what i want is
for the ability in access to create a macro to open and paste these records
automatically without me having to do this copy paste process everyday. i
have tried the excel data import but the nz function is utilised in these
queries and Excel does not find the queries.

can anyone help

thanks in advance
Click to expand...

Take a look at the VBA help for "TransferSpreadsheet". You'll also have to
take the Access function NZ() out of the queries if you expect Excel to be
able to run them; however, if you're just exporting the *data* (rather than
the SQL of the query) the problem should not arise!

John W. Vinson [MVP]
 
Top