View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
R.VENKATARAMAN R.VENKATARAMAN is offline
external usenet poster
 
Posts: 74
Default Automation : from Excel to VB ?

perhaps I have not understood you correctly.
But if the vb-toolbar is avalilable in spreadsheet you click <run macro
icon you get all the macros or subs both in the hidden workbook and also in
"this workbook" you click any macro or sub in the list and click <edit you
go to that routine.
if this is not what you want apologise


PM wrote in message
...
Hello !

I know how to open Excel from VB using Automation.

I do not know how to open VB from Excel.
Is it possible, for instance, to access a Form or a routine of aVB program

?

Thank you for any advice.
And a good day to you all.
Pat.