Hi all;
I'm trying to find out whether the office assistant is installed on a PC during the set-up of XL.
I tried to using the GetObject method, to check if the Assistant is allready running. I will be glad if someone would help me with the code below so that I can understand the method of GetObject.
Sub Test()
Dim MyAssist As Object
Dim AssistExists As Boolean
AssistExists = True
On Error Resume Next
Set MyAssist = GetObject(, "Office.Assistant")
If Err.Number <> 0 Then AssistExists = False
Err.Clear
MsgBox AssistExists
End Sub
I'm trying to find out whether the office assistant is installed on a PC during the set-up of XL.
I tried to using the GetObject method, to check if the Assistant is allready running. I will be glad if someone would help me with the code below so that I can understand the method of GetObject.
Sub Test()
Dim MyAssist As Object
Dim AssistExists As Boolean
AssistExists = True
On Error Resume Next
Set MyAssist = GetObject(, "Office.Assistant")
If Err.Number <> 0 Then AssistExists = False
Err.Clear
MsgBox AssistExists
End Sub