>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...
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement