The following code will return the number constants of paper sizes available. I want to determine the names, xlA4, xlLegal etc. Any ideas?
[VBA]
Sub PaperSizes()
Do
i = i + 1
On Error Resume Next
ActiveSheet.PageSetUp.PaperSize = i
Debug.Print ActiveSheet.PageSetUp.PaperSize
Loop
End Sub
[/VBA]
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Open the Object Browser and search for xlPaperSize.
You will get a list of all the constants, click on one to get the value.
Hey Jake,
Malcolm actually wants to populate a combobox with the PaperSize names, I believe. The object broswer isn't really going to work for him for this.
Ken Puls, CMA - Microsoft MVP (Excel)
I hate it when my computer does what I tell it to, and not what I want it to.
Learn how to use our KB tags! -||- Ken's Excel Website -||- Ken's Excel Forums -||- My Blog -||- Excel Training Calendar
This is a shameless plug for my new book "RibbonX - Customizing the Office 2007 Ribbon". Find out more about it here!
Help keep VBAX clean! Use the 'Thread Tools' menu to mark your own threads solved!
I think you would have to make the list yourself.
PaperB4
PaperB5
PaperCSheet
PaperDSheet
PaperEnvelope10
PaperEnvelope11
PaperEnvelope12
PaperEnvelope14
PaperEnvelope9
PaperEnvelopeB4
PaperEnvelopeB5
PaperEnvelopeB6
PaperEnvelopeC3
PaperEnvelopeC4
PaperEnvelopeC5
PaperEnvelopeC6
PaperEnvelopeC65
PaperEnvelopeDL
PaperEnvelopeItaly
PaperEnvelopeMonarch
PaperEnvelopePersonal
PaperESheet
PaperExecutive
PaperFanfoldLegalGerman
PaperFanfoldStdGerman
PaperFanfoldUS
PaperFolio
PaperLedger
PaperLegal
PaperLetter
PaperLetterSmall
PaperNote
PaperQuarto
PaperStatement
PaperTabloid
Missed PaperA4 - the principal British paper size!
Have a profound problem? Need a ridiculous solution? Post a question in Babydum's forum
You guys always have to be different. Shouldn't it be PaperAU4 tho?
Ahumss the principal European size that is!Originally Posted by Babydum
_________
Groetjes,
Joost Verdaasdonk
M.O.S. Master
Mark your thread solved, when it has been, by hitting the Thread Tools dropdown at the top of the thread.
(I don't answer questions asked through E-mail or PM's)
Thanks to all.
Paper sizes and names resolved here Controlling the Printer from Word VBA
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Wow, I never know paper size can be listed in VBA..
Posting Permissions
Reply With Quote
