View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Rech Jim Rech is offline
external usenet poster
 
Posts: 2,718
Default Calling Macros From VB6

When Excel is opened via automation it does not open any workbooks or add-in
automatically. You would have to add code to your app to open specific
workbooks.

--
Jim Rech
Excel MVP
"Diehard" wrote in message
om...
|I have an excel file with the macro inside the Personal.xls vba
| project, when I open the the file from vb6, it does not open the
| vbaproject(Personal.xls), but, when I open the file anywhere else, it
| show the vbaproject.
|
| What could I be doing wrong in vb6 code.
|
| Your help will most be appriciated.