Hi,

Application.UserControl gives a value of True irrespective of whether I
start Excel through Access or by double clicking the icon. Perhaps it
makes a difference that I have opened excel using the Shell command from
Access? Here is the code:

retVal = Shell(GetExeFileSpec("Excel.Application") & Space$(1) &
filePath, vbNormalFocus)

and this in the Public Function that passes the value to the shell
command

Case "EXCEL":
Set appObj = CreateObject(strEXEHostClass)
strPath = appObj.Path & "\"
strFileName = "EXCEL.EXE"
strPrompt = "Microsoft Excel"

So it does use the CreateObject function, and the file is hidden. What
am I missing here? Thanks for the help, as I said I am new at this.

Jenni

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!