| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SOS! how do I run Excel without running the VBA in AUTO_OPEN? | Excel Discussion (Misc queries) | |||
| running Access procedure from Excel | Excel Programming | |||
| Running Ontime's procedure while another function is running? | Excel Programming | |||
| Opening an Access Database and running procedure Via Excel VBA | Excel Programming | |||
| Auto_Open not running when file opened normally | Excel Programming | |||
Linear Mode
