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.
Scott Dinwiddie