Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Access VBA Formatting Excel .PageSetup Time Consuming Why?
Thank you Andy! I'll simplify the code. For the printer, its a network printer on which I don't have any rights. But I'll make a test on a local printer just to see if it go faster. Cheers/TurtleMx- TurtleMx
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
Access VBA Formatting Excel .PageSetup Time Consuming Why?
Hello All! Does somebody knows why it takes more processor time when setting some .PageSetup properties? See example below: With .Sheets(sSheet).PageSetup .LeftHeader = "" 'Time consuming .CenterHeader = "&A" 'Time consuming .RightHeader = "" 'Time consuming .LeftFooter =...- TurtleMx
- Thread
- Replies: 2
- Forum: Microsoft: Access Modules (VBA Coding)
