S
Snap
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
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