Explain that little (or a lot) moreQuote:
I want to put this code into my existing signed project, but was wondering exactly where one puts the following part
Everything in my little test was in a single standard module, the Declares, the Type UUID, macros, etc.
What happens if you put that in the module? I had everything in just one moduleQuote:
Okay, I solved my previous issue by placing everything except the below into a module.
In that sub there are no 'With' satements, so I'm guessing that an object is not getting Set. The only objects are the xlApps() array
All I can suggest is
1. Put a break point on the line and then Add Watch to investigate xlApps
Also
2. Single step through the code to see if
is not setting the xlApps(n) entryCode:If n = 0 Then
n = n + 1
Set xlApps(n) = app
ElseIf checkHwnds(xlApps, app.Hwnd) Then
n = n + 1
Set xlApps(n) = app
End If
Again the Watch should show how many instances are being found
This is mine with only one instance (different system)
Attachment 28616