ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Personal macros not available when workbooks.open (https://www.excelbanter.com/excel-programming/373114-personal-macros-not-available-when-workbooks-open.html)

Antonio

Personal macros not available when workbooks.open
 
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

Tom Ogilvy

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



All times are GMT +1. The time now is 04:06 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com