| Home |
| Search |
| Today's Posts |
|
#2
|
|||
|
|||
User Error....It works
"Bubba" wrote: I want to open a specific Access DB from and Excel button. I tried a previous sugestion in this forum and It would bring up access but not the file. Here is what I have: (I'm so colse to being happy!) Sub test() On Error Resume Next Set ac = GetObject(, "Access.Application") If ac Is Nothing Then Set ac = GetObject("", "Access.Application") ac.OpenCurrentDatabase "c:\data\temp\temp.mdb" ac.UserControl = True End If AppActivate "Microsoft Access" End Sub |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Open Access Database with VBA | Excel Discussion (Misc queries) | |||
| Excel cannot open Access MDB | Excel Discussion (Misc queries) | |||
| Open Access Database under and Excel window using a Macro | Excel Worksheet Functions | |||
| How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) | |||
| i want to open database exclusively | Excel Discussion (Misc queries) | |||
Threaded Mode
