Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Microsoft Excel VB opening Access Application
Why don't you just add a Quit action at the end of your Autoexec macro in
the Access .mdb? HTH, Nikos "JD Smooth" wrote in message ... Using the following code I'm able to open Access Databases, and with the proper autoexec macro within the database it will run the required tasks. Access however even once it has performed it's tasks and should terminate, it stays running behind the scenes sucking resources. Is there a command that should be added to close access? It never really opens, it simply is running behind the scenes so there isn't a way to close it. Sub start_access1() ' Initialize string to database path. Const strConPathToSamples = "C:\Documents and Settings\rcheek\Desktop\" strDB = strConPathToSamples & "autoruntest.mdb" ' Create new instance of Microsoft Access Set AppAccess = _ CreateObject("Access.Application") ' Open database in Microsoft Access window. AppAccess.OpenCurrentDatabase strDB End Sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Microsoft Excel VB opening Access Application
I do have the quit function within the Access Macro.
*** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Microsoft Visual Basic errors displaid when opening Microsoft Word 97 & Excel (7 | Setting up and Configuration of Excel | |||
microsoft office excel can't start the application | Excel Discussion (Misc queries) | |||
Relation Microsoft Access avec Microsoft Excel | Excel Discussion (Misc queries) | |||
Microsoft Excel is waiting for another application to complete an OLE action | Excel Discussion (Misc queries) | |||
Close Non-Microsoft Application From Excel | Excel Programming |