David,
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?
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.
-- Randy
>There is a KB article acknowledging the problem:
>
>
http://support.microsoft.com/default.aspx?scid=kb;en-us;271856>
>I you are controlling the import from VFP via automation, you could call a Macro after import to look for http:// and force it, as hinted in the article. You also could walk the document from the VFP side via automation, but calling a macro would be faster.
>