Excel page setup problem

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top