Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open Ms Access File
What code can I use to open an Ms Access file from Excel?
Thanks, Milo |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open Ms Access File
Dim acApp as Access.Application
Set acApp = CreateObject(<FileFullName,Access.Application) Notes: <FileFullName needs to include the full path name to the file, the file name and including the file's up to 3 letter extension. Before running this code, you will need to be sure that you have in your Excel VBA a reference to Access, which can be gotten to by ToolsReferences within your VBE window. To refer to the Access application/file, you will need to use the acApp variable to prequalify your Access objects, unless the code is using a variable that already reference to the object(s). -- Ronald R. Dodge, Jr. Production Statistician Master MOUS 2000 "milo" wrote in message ... What code can I use to open an Ms Access file from Excel? Thanks, Milo |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I need open or gain access to an external file | Excel Discussion (Misc queries) | |||
Can I open a file with access denied for no known reason? | Excel Discussion (Misc queries) | |||
Prevent Access To already open file | New Users to Excel | |||
How can I open an Access adp file from excel? | Excel Discussion (Misc queries) | |||
How can I open an Access adp file from excel? | Excel Discussion (Misc queries) |