Using VBA to open Excel , Auto_Open Procedure not running
Hi Reader
I have below code for Open Excel by VBA. The Excel have Auto_open Procedure can not able to run. I already set Secuiry Level to Low. How to chang below coding ? On Error GoTo OpenError Workbooks.Open Filename:=loFilename, UpdateLinks:=2 On Error GoTo 0 |
Using VBA to open Excel , Auto_Open Procedure not running
When you open a workbook with VBA code, the Auto_Open macro does not run.
This is by design. You can run them with code like ActiveWorkbook.RunAutoMacros xlAutoOpen -- Cordially, Chip Pearson Microsoft MVP - Excel, 10 Years Pearson Software Consulting www.cpearson.com (email on the web site) "moonhk" wrote in message ups.com... Hi Reader I have below code for Open Excel by VBA. The Excel have Auto_open Procedure can not able to run. I already set Secuiry Level to Low. How to chang below coding ? On Error GoTo OpenError Workbooks.Open Filename:=loFilename, UpdateLinks:=2 On Error GoTo 0 |
Using VBA to open Excel , Auto_Open Procedure not running
On 11 2 , 6 38 , "Chip Pearson" wrote:
When you open a workbook with VBA code, the Auto_Open macro does not run. This is by design. You can run them with code like ActiveWorkbook.RunAutoMacros xlAutoOpen -- Cordially, Chip Pearson Microsoft MVP - Excel, 10 Years Pearson Software Consultingwww.cpearson.com (email on the web site) "moonhk" wrote in message ups.com... Hi Reader I have below code for Open Excel by VBA. The Excel have Auto_open Procedure can not able to run. I already set Secuiry Level to Low. How to chang below coding ? On Error GoTo OpenError Workbooks.Open Filename:=loFilename, UpdateLinks:=2 On Error GoTo 0- - - - Than, It works My coding as below On Error GoTo OpenError Workbooks.Open Filename:=loFilename, UpdateLinks:=2 ActiveWorkbook.RunAutoMacros xlAutoOpen On Error GoTo 0 |
All times are GMT +1. The time now is 06:40 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com