Pat,

Check out the "Shell" function for running another compiled application.

Your VBA code may be hidden from view and password protected. In the VBA
editor, right click your project in the project window, then VBA Project
Properties...

Dale

"PM" wrote:

Hi !

I know how to open a workbook from VB6 using Automation.
But can I open a VB program from Excel?

(a) I don't seem to find the adequate objects in the VB library...
(b) If the answer is yes, then what about compiled VB code ??

I bet the general question is : since I read on this very page that "I you
dont want to share data, don't put it in Excel", then how do I efficiently
hide my code from unauthorized viewers ? My idea was to use VB...

Hope you great wizzards can give me a hint or a reference !

Pat