Hi Bret,

The best way to work with VFP and Excel is to use the macro recorder
and 'steal' from the results.

VBA uses intrinsic constants--you see these when you use the Macro Recorder (which is a GREAT way to learn to automate Excel). VFP, however, does not have these values as a part of its language. To find these values, use an Object Browser. Excel's is available within Excel by Alt-F11, then F2. If you have VFP 7, use its own Object Browser. You can search for the constant name, and the value is shown in the bottom panel.


Ger