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.
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" ?
Thanks again
Terry
- 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.