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