Page Set Up Reports via code

[JoseSharp]

Hi, I am using a Dbs to report information to excel. The users want the excel workbooks formated. On each worksheet's code I have page set up coding but only the first page works the remaining two are not formated. The code is:

'change page setup
.PageSetup.Orientation = xlLandscape
.PageSetup.FitToPagesWide = 1
.PageSetup.FitToPagesTall = 1

Does anyone know a better way to do this or why the code is not formating correctly



If you can help me out then you will be

thanks

 

[llkhoutx]

O'Reilly's Access Database 2nd edition has to code you want.