View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Snap Snap is offline
external usenet poster
 
Posts: 1
Default 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