>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.
You need to replace the VB generated Excel constants with their actual value.
Go to the Classes-VCX located in the Files section here on the UT. Look for "Excel 97 Constants" download posted by Garrett Fitzgerald. It contains VFP defines for the constants.
Michael McLain