>Cetin,
>
>Thankyou for your help, this works perfectly - I had spent nearly 2 days trying to find a way of doing this.
>Just one more thing - is there a resource to find out the syntax for sending OLE commands - the documentation with VFP 5.0 doesn't cover this at all.
>
>Again, Thankyou for your time.
>
>Martin
Martin,
Documentation installs with Office (if VBA help is enabled - otherwise install from CD).
They're vba???.hlp (??? = xl8 for excel97, vbaxl9.chm for excel2000). You will need a lot of constants (that were #define(d) in sample). There are files having those constants at "files section" AFAIK (Also wc0993.exe from microsoft site has all office constants - exact URL ?). In any case if you cannot find those constants :
-Open Excel
-Select tools\macro\VB editor
-Press F2 to bring up "Object browser"
-Find needed xlConstant type ie:xlChartType
-On right window click needed Constant ie: xl3DArea
-Below the window constant value is displayed
Cetin