View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default Scope of variable

Assuming you have created a standard .exe in VB6 then basically no. You
would need some other means of the communication with the app's internal
variables.
If you make an ActiveX exe (or dll for that matter), with classes and public
properties etc, then yes you can see those Public member, the same as you
can see Excel's properties, methods etc.

NickHK

"avi" wrote in message
oups.com...
Hello,

I have written an EXE file in VB6 that i call from a VBA module. In
the EXE file i declared Public a variable 'aaa'. Is that variable
available in the VBA code or should i do something to make it
available?

Thanks a lot
Avi