Hide Access running from excel spreadsheet

  • Thread starter Thread starter Souris
  • Start date Start date
S

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,
 
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
 
Back
Top