Switch on Excel Macro Dialog from Access procedure

[Binnit]

I have the following code in a form module

Set oApp = CreateObject("Excel.Application")
    oApp.workbooks.Open strDir

The workbook has macros within it and would normally open up with the dialog box asking for confirmation to enable them.

However, this code does not fire up the dialog and just opens the workbook without macros enabled

How can I build the dialog option in to this code?
I would imagine it to look something like:-

oApp.Application.MacroOptions = True


Happiness is...not getting what you want but wanting what you have already got

 

[NorthNone]

Maybe this will help you? I'm no expert, but it looks promising...

http://support.microsoft.com/kb/317405

Good luck
NorthNone

"Character cannot be developed in ease and quiet. Only through experience of trial and suffering can the soul be strengthened, ambition inspired, and success achieved." - Helen Keller