>Thanks ever so much, Hilmar. Something like your article is exactly what I need. My compliments on the clear, concise and easy-to-follow presentation.
Thanks.
>Just one thing though. I recorded a macro as I opened up one of my w/s, and got:
>
>Workbooks.Open Filename:="C:\Temp\exports\C3AN0200.XLS"
>
>After I've exported my VFP table to excel I want to open the w/s and change the col. headings to those of my field captions. Do I take it that this would translate, in VFP, to something like:
>
>loExcel.Workbooks.Open Filename:="C:\Temp\exports\C3AN0200.XLS" ?
Tamar answered your question; I just wanted to point out that I mentioned this in my article, too (the problem with the named parameters).
As far as I have seen, a macro saved with named parameters will give the parameters in the correct order for the alternate syntax. So, you just take the name away for each parameter, and add parentheses.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
