Word vba page setup

When the macro runs, the dialog will continue to report the paper size as A4, but "Use custom page size" is enabled and the paper size is set to the dimensions for US Letter. Note the CentimetersToPoints conversion function being recorded: that's because my system runs in metric.

If you set your measurement units to Points before you record, you will record the raw parameters. There is no benefit to doing this: Word's native unit is the "Twip" which is a twentieth of a point, so it's going to convert the measuerments whichever one you use.

With ActiveDocument. Reply to author. Report message as abuse. Show original message. Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message. Hi Aron: Yes, it will. John, I wish it was this simple. But as I said, I've recorded myself making the change, and when I run the recorded macro it does not work.

The macro creates the registry entry if it is not present and then toggles the setting between 0 and 1 each time the macro is run. It could therefore be adapted for use in a mail merge macro to switch off the warning while the particular merge was run, then switch it back on again on completion. Graham Mayor You appear to be using ad blocking software. While I respect your right to do so, please be aware that the minimal advertising on this site helps defray the cost of providing this facility, and I would therefore ask that you turn off the blocker while browsing this site.

Many people access the material from this web site daily. Most just take what they want and run. That's OK, provided they are not selling on the material as their own; however if your productivity gains from the material you have used, a donation from the money you have saved would help to ensure the continued availability of this resource.

Click the appropriate button above to access PayPal. Range oRng. Start - 1 With oRng. Fields 1 If InStr 1,. Update End With oRng. Collapse 0 oRng. I use custom paper sizes. Unfortunately Word appears to set all of these to papersize 41 However, at least in my case, when I set paperzize to 41 and then change the margins to a specific size, the papersize name is correct.

Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Asked 6 years, 5 months ago. Active 7 months ago. Viewed 4k times. Selection objDoc. Deduplicator Leah W Leah W 11 1 1 silver badge 1 1 bronze badge.

Are you getting an error? Hi there, no error at all. It just opens with the letter page size. Add a comment. Active Oldest Votes.