Randy,
>Thanks that's interesting. Where would you put a macro like that? I wouldn't want it in the XLS file itself. Is there a place you can put utility functions such that they can be run on any open spreadsheet?
There may be a way to create a macro on the fly via automation and then remove it when done. There must be something about macros in the object model.
>Hmm. Maybe there's no point in that. Easier just to add the automation code within the VFP function. Performance is a non-issue here.
Yep, if performance is not an issue, then performance of the developer may dictate using what you know already -- although the dynamic macro creation/disposal seems intriguing. Maybe I'll add it to the few hundred other ideas I want to check out some day. :-)