>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.
Try
oexcel.activesheet.pagesetup.orientation = 2
HTH
Jeff
It's Time to get a gun.
That's what I've been thinkin.
I think I can afford one, If I do a little less Drinkin.www.TrueGeeks.com