Using VBA to open Excel , Auto_Open Procedure not running

[moonhk]

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

 

[Chip Pearson]

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]

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)











- -

Than, It works

My coding as below
On Error GoTo OpenError
Workbooks.Open Filename:=loFilename, UpdateLinks:=2
ActiveWorkbook.RunAutoMacros xlAutoOpen

On Error GoTo 0