I've made a minor breakthrough. 2 actions that seem to help the stability. First: When issuing a VB command to Call the Activehome object, TRy the following sequences
Dim ActiveHomeObj As ActiveHome
Set ActiveHomeObj = CreateObject("X10.ActiveHome")
Dim W, X, Y, Z As Integer
Dim Str2 As String
Str2 = "A1 On"
Call ActiveHomeObj.SendAction("sendplc", Str2, 1, 1)
' Where Str2 = Address Action (on or Off)
' The , 1, 1 after the variable seems to improve reliability
' Add a slight Delay after issuing the Command
For X = 1 To 100
Y = X
Next X
End Sub
The second acction was to insert the following statements at the head of each routine that either directly or indirectly calls Activehome.Obj.SenAction Command.
Dim ActiveHomeObj As ActiveHome
Set ActiveHomeObj = CreateObject("X10.ActiveHome")
I had several routines that called "driver routines" that actually issued the X10 command. Whenever the driver routines completed and returned to the calling routine, Excel shutdown. By having the Dim & Set commands at the beginning of the parent routines, the problem disappeared.
This is working great with Excel's version of VB. I can't verify it with the full blown VB package