excel print settings - page breaks

[oneillst]

Currently I export a table in Access into Excel and format the spreadsheet via VBA code. I can do everthing needed except adjusting the page breaks for printing. Does anyone know how to do this !

 

[Dreamboat]

What do you need to adjust and why? Virtually anything you might want to do in Excel can be done more easily with an Access report...

Anne Troy

http://www.TheOfficeExperts.com

Word and Excel Macros
Coming soon: wX

 

[oneillst]

Reports are usually produced via Access and emailed to recipients or via intranet applications however this report has been requested in a spreadsheet format. I have been able to adjust all printing settings except for where the pagebreaks occur.

 

[Dreamboat]

I'll ask again, but differently.

WHAT determines where the pagebreaks should go?

Anne Troy

http://www.TheOfficeExperts.com

Word and Excel Macros
Coming soon: wX

 

[oneillst]

All that has to occur is that the pagebreak has to go to the edge of the spreadsheet

 

[misterstick]

in that case try

ActiveSheet.PageSetUp.FitToPagesWide = 1



mr s. <

 

[oneillst]

I have tried this but it still doesn't work. I am working with Office 97. Within Access when I code for excel to go into print preview mode it locks up. At the moment I will just do this manually.