Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open and Enable xla file from vba code?
Hi -
I am trying to open an add-in (xla file) from vba but I am not prompted to "enable macros" on it...so the xla file is rendered useless. My security setting are fine. I can open add-ins via double click or dragging them into a workbook and I receive the "enable addins" message box. Here is the code I am using: Public Sub OpenAddIn() Workbooks.Open Filename:="\xxxxxxxxxx.xla" End Sub Is it possible to open an add-in via vba with macros enabled? Thanks, Jason |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open and Enable xla file from vba code?
yes it is possible since i do it myself
thought i dont see what is wrong with your code put macro security to lowesst level may be "Snap" wrote: Hi - I am trying to open an add-in (xla file) from vba but I am not prompted to "enable macros" on it...so the xla file is rendered useless. My security setting are fine. I can open add-ins via double click or dragging them into a workbook and I receive the "enable addins" message box. Here is the code I am using: Public Sub OpenAddIn() Workbooks.Open Filename:="\xxxxxxxxxx.xla" End Sub Is it possible to open an add-in via vba with macros enabled? Thanks, Jason |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
open file with code | Excel Discussion (Misc queries) | |||
Map drive to open a file with code | Excel Programming | |||
Don't open file if no response to enable macros | Excel Programming | |||
How to open a zip file from the code? | Excel Programming | |||
VBA code to open file? | Excel Programming |