>The main difficulty with saving macros is usually getting numeric constants for the Excel defined-constants.
There are several places to get these. First is opening an Object Browser (either in Excel '95 or later, or in VFP7). Type in the name of the constant and it shows you the constant's value.
Another way is to get a product that reads the type library. Rick Strahl has a nice one called GetConstants at
www.west-wind.com. It finds all the constants, and creates a loooooong VFP .h file. You'll want to keep this file on your disk somewhere, but the one you actually attach should be a short version using only the groups of constants you need, unless you like your source code to take very long to save and compile.
Lastly, search the UT and I'm sure there are .h files out there listing all the constants.
HTH,
- della