Please Note: This text is the complete reproduction of Chapter 17 - Security if Microsoft Office from my book RibbonX: Customizing the Office 2007 Ribbon, and is reproduced with permission of Wiley Publishing who retains the copyright of this work.
This chapter was obviously written for Excel 2007, and still holds true for Office 2010.
In addition, this chapter also discusses macro security applicable to Office 97 through Office 2003. Key portions to read for these versions are
Security Prior to Office 2007 and
Digital Certificates. While some of the screens may look a little different, they should be close enough to help you understand how to set up a SelfCert digital certificate and add it to your projects. These steps will allow you to avoid macro warnings in your programming environment, without having to sacrifice security by setting your security levels to low.
...
Get a table from each Excel file in folder | speed up the process
Thanks for Text.Upper trick!...
marcob8986 Today, 04:37 PM