Business Solutions VBA for the 2007 Microsoft Office System

14VBA Tips and Techniques

IN THIS CHAPTER

Working with Modules

Configuring Macro Security Settings

Digitally Signing a VBA Project

Saving Application Settings in the Registry

Accessing the File System Through VBA

Tips for Faster Procedures

Although I’ve labeled this a “Tips and Techniques” chapter, it’s more like a hodgepodge of miscellaneous VBA ideas and methods that simply didn’t fit anywhere else in the book. Although you can write powerful and useful VBA applications without using any of the techniques I’ve outlined in this chapter (with the possible exception of the section “Tips for Faster Procedures”), they’re indispensable when you do need them. For example, if you want to run your own VBA projects without having to enable the ...