| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
open access from excel ?
Hello,
What is the code (if possible) to open access application from excel ? thank you -- תודה רבה |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
open access from excel ?
Hi ?
Try this to open C:\OrderDatabase.mdb Sub test() Dim ac As Object On Error Resume Next Set ac = GetObject(, "Access.Application") If ac Is Nothing Then Set ac = GetObject("", "Access.Application") ac.OpenCurrentDatabase "C:\OrderDatabase.mdb" ac.UserControl = True End If AppActivate "Microsoft Access" End Sub -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "יריב החביב" wrote in message ... Hello, What is the code (if possible) to open access application from excel ? thank you -- תודה רבה |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
open access from excel ?
Thank YOU
-- תודה רבה "Ron de Bruin" wrote: Hi ? Try this to open C:\OrderDatabase.mdb Sub test() Dim ac As Object On Error Resume Next Set ac = GetObject(, "Access.Application") If ac Is Nothing Then Set ac = GetObject("", "Access.Application") ac.OpenCurrentDatabase "C:\OrderDatabase.mdb" ac.UserControl = True End If AppActivate "Microsoft Access" End Sub -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "יריב החביב" wrote in message ... Hello, What is the code (if possible) to open access application from excel ? thank you -- תודה רבה |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to open a secured Access db from Excel | Excel Discussion (Misc queries) | |||
| EXCEL TRIES TO OPEN IN ACCESS | Excel Discussion (Misc queries) | |||
| Excel won't open - pasting from Access | Excel Discussion (Misc queries) | |||
| Excel cannot open Access MDB | Excel Discussion (Misc queries) | |||
| How can I open an Access adp file from excel? | Excel Discussion (Misc queries) | |||
Linear Mode
