>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.
Thats true, although it isn't hard to find out what those enumerated constants are. I found that once I had gotten used to it, it was pretty easy to translate those macros to automation calls. I usually used the macro recorder as a way of getting a look at the VBA code that I would end up translating.
Jim Newsom
IT Director, ICG Inc.