P
Phill
I have an Access 2003 app that pushes some data into Excel. I use the
following code to format the page setup for the users, but it doesn't format
the page. I don't get any error messages. I recorded a macro in Excel to
make sure I had the right settings. Any ideas? This is my code:
With xl.Windows(1).ActiveSheet.PageSetup
.PrintArea = "$A$1:$U$46"
.PaperSize = xlPaperLegal
.Orientation = xlLandscape
.FitToPagesWide = 1
.FitToPagesTall = 1
End With
following code to format the page setup for the users, but it doesn't format
the page. I don't get any error messages. I recorded a macro in Excel to
make sure I had the right settings. Any ideas? This is my code:
With xl.Windows(1).ActiveSheet.PageSetup
.PrintArea = "$A$1:$U$46"
.PaperSize = xlPaperLegal
.Orientation = xlLandscape
.FitToPagesWide = 1
.FitToPagesTall = 1
End With