Greetings,
I am constructing a spreadsheet within Access that I ultimately want to spin out to a "11x17" landscape PDF.
I keep getting the "Unable to set the Paper Size of the PageSetup class." error (1004). I've tried using xlPaperTabloid and get the same error. I've also tried using the actual numeric for xlPaper11x17 (which is 17) and that doesn't work.
I've set my default printer to a printer that accomodates 11 x 17.
I've recorded a macro that worked and pasted that into my code, but it still errors out on the PaperSize line.
I've seen LOTS of posts regarding this issue, but haven't found a solution. Any help would be appreciated! Code is shown below.
Jonathan Mulder
California Department of Water Resources
Red Bluff, CA USA
Bookmarks