Retrieving Acces Querry by Use of Macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can anyone tell me wheter it is possible to get a macro to open an existing
querry. Change a criteria. Select the data. And Paste it in Excel? I tried it
with recording a macro, but it doesn't seem to record anything outside excel.
Thanks I advance,

Jasper
 
Try retrieving your data with Data=>Get External Data or Data=>Import
External Data (depending on version).

If you are successful with that, then you can repeat it with the macro
recorder on and it will be recorded.

You can then generalize that code to do what you want.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

including a macro in all workbooks 4
Use MACRO to export queries to specific SHEETs in ONE Excel file? 6
How do I set up a querry that copies and pastes 1
Wrong import values from webquerry 1
Programatically changing the macro content. 1
Excel 2003: Printing a worksheet and setting properties 1
Streamlining macro created by macro recorder 3
how to select any last record in the querry 5

Back
Top