[RESOLVED] page setup=landscape in excel

[juve11]

hi, i want to make an excel file from visual basic wich is landscape

my code is this

oSheet.PageSetup.Orientation = Excel.Constants.xlLandscape

and it has the error xllandscape is not a member of excel.constants

[Hack]

That is because it isn't a member of excel.constants

The orientation belongs to the Workbook.Worksheet

Do you have variables for them?

[juve11]

Done it

oSheet.PageSetup.Orientation = XlPageOrientation.xlLandscape

thank you very much for youre post, it's a great forum with quick support!

[Hack]

You are welcome.

If you consider this resolved, you could help us out by pulling down the Thread Tools menu and clicking the Mark Thread Resolved menu item. That will let everyone know that you have your answer.

Thank you.

[juve11]

done.

my best regards!