Macro using problem.

  • Thread starter Thread starter Dawn
  • Start date Start date
D

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
 
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.
 
Back
Top