If you are using a template, you can create the macro and save it in Excel, then run the macro from VFP using oexcel.Run('MyMacro'). That way you don't have to worry about constants.
John Harvey
Shelbynet.com
"I'm addicted to placebos. I could quit, but it wouldn't matter." Stephen Wright 
