Eduardo Fuerte
asked on
Could you point a way or possibly free tool you ever know to convert a complex report FRT to an Excell sheet?
Hi Experts
Could you point a way or possibly free tool you ever know to convert a complex report FRT to an Excell sheet?
By complex I mean, accordingly with the picture, data for 03 diferent DBF(s)
So by using:
Doesn't solve the entire needs.
Thanks in advance!
Could you point a way or possibly free tool you ever know to convert a complex report FRT to an Excell sheet?
By complex I mean, accordingly with the picture, data for 03 diferent DBF(s)
So by using:
Copy Fields Desp, Tp_mv, Val1, Val2, Val3, Val4, Val5, Val6, Val7, Val8, Val9, Val10 To (n_cx) Type Xl5
Doesn't solve the entire needs.
Thanks in advance!
ASKER
Hi
I had used VFP automation before, a very impredictable and time consuming operation....
I had used VFP automation before, a very impredictable and time consuming operation....
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi
Since I avoid VFP automation as I could due its impredictable behavour my option was to do an UNION between the tables.
Since I avoid VFP automation as I could due its impredictable behavour my option was to do an UNION between the tables.
That tool is VFP Automation of Excel.
By using VFP's Automation you can write your data to the Excel file directly cell-by-cell and put anything else into the Excel file you want.
Sure it may not be quick-and-easy to write all of your Automation code, but it works very well and it is 'free' for owners of VFP.
From the web you can get many examples of VFP Automation of Excel.
Good Luck