I am trying to automate some excel printing within my VFP application. I am able to print ok, but I need the spreadsheet to be landscape and to always print rows 1 and 2 on each page.

I have included the necessary .h files (office97.h and xl97cons.h). Within the xl97cons.h, it denotes xlLandscape as a constant. Once my code gets to the following lines, I get a runtime error (invalid number of parameters):

ObjExcel.ActiveSheet.Pagesetup.Orientation(xlLandscape)
ObjExcel.ActiveSheet.Pagesetup.PrintTitleRows("1:2")


The error occurs when trying to make landscape. I am not sure if the PrintTitleRows syntax is correct.

Please HELP!!!!!