Run-Time error '91'

[jovir]

Hello
I'm working on an app developed in VB6 with interaction with Excel VBA
There are two functions that Utilization properties Excel.Application
How to use Excel.Application object in both functions?

***********************************

Please Login or Register  to view this content.

***********************************
***********************************

Please Login or Register  to view this content.

***********************************
_________________________________________________________
|Run-time error 91 (Object variable or with block variable not set).|
_________________________________________________________

[romperstomper]

Store the variable at module level, not procedure level

Please Login or Register  to view this content.