| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Opening ,copying, access query resultsfrom Excel
I've seen this code somewhere- please
give me a template code in Excel VBA - i want to open (from Excel ) multiple MS access queries and copy them automatically to multiple worksheets . Help!! Danail |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Opening ,copying, access query resultsfrom Excel
Probably in the macro recorder. Select the sheet and do Get = External
Data. Modify the recorded code to handle each of the databases you want to import to be placed in the proper location. -- Regards, Tom Ogilvy "Danail" wrote in message ... I've seen this code somewhere- please give me a template code in Excel VBA - i want to open (from Excel ) multiple MS access queries and copy them automatically to multiple worksheets . Help!! Danail |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Query from Access into Excel cause Access to go to read only | Excel Discussion (Misc queries) | |||
| Opening an ACCESS db from the VBE in EXCEL | Excel Worksheet Functions | |||
| Can I use MS Query in Excel like an Append Query in Access | Excel Discussion (Misc queries) | |||
| How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) | |||
| Access query vs. Excel query | Excel Programming | |||
Linear Mode
