I read on Google that this is a known issue with Excel, but I couldn't find any suggestions that worked for 2003 or that made a noticeable impact. Here's the code I'm using:

With m_xlSheet.PageSetup
.LeftMargin = Application.InchesToPoints(0.5)
.RightMargin = Application.InchesToPoints(0.5)
.TopMargin = Application.InchesToPoints(0.5)
.BottomMargin = Application.InchesToPoints(0.5)
.Orientation = xlLandscape
End With

This code runs 4 times (once each for 4 worksheets). I'm running it from a VB DLL. I have already set

m_xlApp.ScreenUpdating = False

but this didn't make much of a difference -- likely because the entire workbook is not visible until the end of my code.

Without the page setup code, it takes 4 seconds to create a new workbook, 4 sheets, and populate them with data. With the page setup the time goes to 9 seconds.

Any ideas? Thanks,

--
JT Lovell