>Quick question:
>
>We are accessing Excel from VFP and want to change the orientation of the worksheet to landscape. When we record a macro it shows ".ORIENTATION = .xlLandscape". However, VFP doesn't understand xlLandscape saying "Variable not found". How can we get around this?
>
>Here's a sample of our code to clarify....
>
>oexcel = createobject('excel.application')
>oexcel.workbooks.add
>oexcel.activesheet.pagesetup.printheadings = .f.
>oexcel.activesheet.pagesetup.orientation = xlLandscape
>
>
>Thanks in advance for your help.

Here is the way I like to find the constants. With Excel running,
select ALT-F11 then F2. That will bring up the Excel Object browser
and you can type in what you like. For example, 'xllandscape' will
return a value of 2 at the bottom of the form.

Using this and the Macro recorder in Excel make doing Excel automation
fairly easy. At least they are of tremendous help to me...