View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Piers 2k Piers 2k is offline
external usenet poster
 
Posts: 11
Default CreateObject - start Access from Excel

Hi folks,

Am trying to start an Access database from VBA, but it closes itself when
the code finishes. I simply don't want this to happen. The following code
works fine if I change the Access into Word (see the comment):

Sub StartApp()

Dim OtherApp As Object

' Set OtherApp = CreateObject("Word.Application")
Set OtherApp = CreateObject("Access.Application")

OtherApp.Visible = True

End Sub

Any help please?
TIA,

Piers