Macro using problem.

[Dawn]

Question Background:
I have to do some monthly report form, because the weakness of Access Form,
I have to do lots of Queries to generate original data source, that I have
to copy all the results of Queries into Excel , to fulfill the monthly report
form. Of course I can do it manually, running a query , ctrl-c of the result
, than ctrl-v to the excel, but it’s boring especially there are about 100
queries awaiting.
Question:
How can I use the A macro to realize as follows:
Automatic open a query , copy its result, paste into a sheet of an excel
(better can appoint the start cell of a sheet to put the results, because
the queries are too many, I don’t want one query adds one sheet)
And do it in queries one by one.
Thanks.
Dawn

 

[bhicks11]

Hi Dawn,

In the Macro -

openQuery
TransferSpreadsheet

etc., until all your tables have been exported.

bhicks11
http://www.dataplus-svc.com

 

[Steve Schapel]

Dawn,

If you don't mind me saying... It really sounds like you have a
fundamental error in the design of your database. This type of
operation should never be necessary. Are you able to consider a
revision of your table model? If so, there are people who can help.