where are the macros so that I can modify them?

On Friday, December 12, 2008 5:44 PM bmatu wrote:

I would like to automate the running of macros in a number of Excel workbooks
(.xlsm files) with a VB.Net application.

The problem is that when the macro completes, and the code tries to save the
.xlsm file, I get the following privacy warning:
"
Privacy warning: This document contains macros, ActiveX controls, XML
expansion pack information, or Web components. These may include personal
information that cannot be removed by the Document Inspector.
"

Is there a way to suppress the warning, or to "OK" it implicitly? I checked
the Trust Center options, but couldn't find a setting that would disable this
warning.

Thanks!


On Friday, December 12, 2008 8:06 PM FSt wrote:

hi
put this before the save perfered at the start of the macro.
application.displayalerts = false

then at the end of the macro, before end sub
application.displayalerts = true.

i have not tried this in 07 but it works quite well in 03.
regards
FSt1

"bmatuk" wrote:


On Saturday, December 13, 2008 12:24 PM bmatu wrote:

Thank you very much for your quick and accurate response!
Yes, it works wonderfully in Excel 2007.

Thanks for your help!!!

"FSt1" wrote:


Submitted via EggHeadCafe
Office Open XML File Formats - Word 2007
http://www.eggheadcafe.com/tutorials...word-2007.aspx