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.