Make everything fit on one excel page 1

[LonnieJohnson]

In access when creating a report you can choose in the wizard to have everything fit on the page. Is there anything simular when creating a worksheet from access in excel to have everything fit?

ProDev, MS Access Applications
Visit me at ==>

http://www.prodev.us

May God bless you beyond your imagination!!!

 

[PHV]

With yourExcelObject.ActiveSheet.PageSetup
.FitToPagesWide = 1
.FitToPagesTall = 1
End With

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[LonnieJohnson]

I wish I could give you two stars for this one.

ProDev, MS Access Applications
Visit me at ==>

http://www.prodev.us

May God bless you beyond your imagination!!!