Hide Access running from excel spreadsheet

[Souris]

Dim MyDB As Object

Set MyDB = GetObject("c:\MyDB\MyDB.mdb")
MyDB.Application.Run "Myfunction", MyValue
Set MyDB = Nothing


I have above code to run a function in Access datadabse from Excel
spreadsheet which launch MS Access when run the code from Excel.

I use version 2003

Is it possible to hide Access from end user whicl run the function?

Your information is great appreciated,

 

[Douglas J. Steele]

Untested, but try

Dim MyDB As Object

Set MyDB = GetObject("c:\MyDB\MyDB.mdb")
MyDB.Application.Visible = False
MyDB.Application.Run "Myfunction", MyValue
Set MyDB = Nothing