Thanks a lot, Tamar. That's the final piece in the jigsaw and now I've got it. And thanks for the heads-up on the book.
Terry
>No, VFP doesn't use named parameters. When you translate from a macro to VFP Automation code, you have to replace named parameters with positional parameters. Your example becomes:
>
>loExcel.Workbooks.Open("C:\Temp\exports\C3AN0200.XLS")
>
>In general, the Excel VBA Help file is invaluable here. In addition, as others said, the book Della Martin and I wrote has a lot of this in it, as well as a whole chapter really devoted to the question of how you learn what commands are available.
>
>Tamar
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.