Disabling macros while openning Excel files
My development required open and read Excel file with macros inside.
I’ve used my standard lib to open and read file-turned out that Excel macro displays dialog expecting user option selection.
What I’ve looked for was possibility to disabling Excel macros at all.
I’ve googled a lot and finally found msoAutomationSecurityForceDisable as solution.
Example:
I’ve used my standard lib to open and read file-turned out that Excel macro displays dialog expecting user option selection.
What I’ve looked for was possibility to disabling Excel macros at all.
I’ve googled a lot and finally found msoAutomationSecurityForceDisable as solution.
Example:
Labels: Excel
0 Comments:
Post a Comment
Subscribe to Post Comments [Atom]
<< Home