Open and Enable xla file from vba code?

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
 
J

jerome drean

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top