I'm assuming what the problem is here. But xlLandscape is a VB constant. There is a list of the constants here in the file section somewhere. If you include that file, it should work.

Pf


>I am automating a process of opening an excel spreadsheet and doing pagesetup options before sending it to the printer. I recorded a macro in excel and attempted to incorporate it into my code. I included the following to print landscape and to repeat rows 1 and 2 on every page:
>
>ObjExcel.ActiveSheet.Pagesetup.Orientation(xlLandscape)
>ObjExcel.ActiveSheet.Pagesetup.PrintTitleRows("$1:$2")
>
>The code is not working properly. Could you please assist me with the correct syntax.
>
>Thanks.