Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a set of Workbooks that I use each month to compile stats etc, One is
called M76, it contains a user form with various Macros etc to maniplulate the data, The Data Source is and Access database Called DP2, I have a pre built query within there that I run to get the months data, What I want to do is insert a new user command in the excel workbook's form which I can click and it runs off and gets the data for me, I have managed to get excel to open Access but cannot get it to go straight to the database in question, and then to the particular query and or macro that runs the query? Is it possible to do this, if so any suggestions would be gratefully received Thanks In Advance JTA |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
"Cannot access read-only document" (I get this error when I try to open an Excel file) | Excel Discussion (Misc queries) | |||
Started out as an Access problem. Now an Excel problem | Excel Discussion (Misc queries) | |||
Excel Access and Oracle | Excel Discussion (Misc queries) | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Microsoft Access Report into Excel Spreadsheet | Excel Discussion (Misc queries) |