Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Retrieving Acces Querry by Use of Macro
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Retrieving Acces Querry by Use of Macro
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. -- Regards, Tom Ogilvy "Jasper" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to run acces 2003 macro in excell 2003 macro | Excel Discussion (Misc queries) | |||
querry | Excel Discussion (Misc queries) | |||
macro for retrieving a set of data from excel sheet | Excel Discussion (Misc queries) | |||
Use two different value to run a querry | Excel Discussion (Misc queries) | |||
Retrieving Values from Cell with Macro | Setting up and Configuration of Excel |