View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 6,953
Default Personal macros not available when workbooks.open

If you open excel via automation, it doesn't load addins or files in the
xlstart directory or in any of the startup directories. If you need
personal.xls, then open it as well.

--
Regards,
Tom Ogilvy


"Antonio" wrote:

When I open a workbook with workbooks.open the macros in personal.xls are not
accessible.

I need to open the workbook manually to get access to the macros.

Thanks,

Antonio