Re: Getting values of pagesetup for passing arguments to xl4 page.setup function.

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: masayoshi hayashi (mhayashi_jp_at_yahoo.com)
Date: 03/24/04 

Date: 24 Mar 2004 02:36:08 -0800

Thanks Tom for the links.

I figured out Get.Document() function returns page setup values. But
while attempting to extract a value from the array returned from
Get.Document(52),
it seems to return only a single value, not an array.

The macrofun help for Get.Document(52) function states:
52 Four-item horizontal array indicating the margin settings (left,
right, top, bottom) in the currently specified units.

In the Immediate window of Excel 2002, I tried
?ExecuteExcel4Macro("Get.Document(52)")
This returns a single value in Double for left margin.

?isarray(ExecuteExcel4Macro("Get.Document(52)"))
False

Am I missing something here or how would you get right, top and bottom
margin values from Get.Document(52) function?

Relevant Pages

  • Re: Missing Bottom Border
    ... there is a Page Setup group. ... the small arrow in the bottom right corner of that group. ... Borders and Shading dialog (changing the Page Border setting from "Edge ... bottom margin is still too small or you have the page border surrounding ...
    (microsoft.public.word.pagelayout)
  • RE: Printing not according to set margins.
    ... Layout) instead of the bottom page margin (File | Page Setup | Margins). ... and you applied the bottom margin change to one particular section ...
    (microsoft.public.word.docmanagement)
  • Margins
    ... when I set all my margins in Page Setup to 3 cm all ... round (top bottom left & right) that it doesn't print that way? ... margin measures 2 cm and my right margin measures 4 cm? ...
    (microsoft.public.word.pagelayout)
  • Odd Page Layout Problem with Word 2002 in Office XP
    ... I've made up a very simple document that is a home inventory. ... The third line on the first page is a sub-subtitle in 14pt Bold/Underline ... Near the bottom of the 5th page is the third sub-subtitle. ... text to this page without overflowing the bottom margin. ...
    (microsoft.public.word.pagelayout)
  • Re: printer margins (ok on first page only)
    ... Actually the Top and Left margins will be fine, but the Bottom margin certainly will not be, and neither will the Right margin! ... BottomMarginWidth As Long, PrintableWidth As Long, _ ... Dim LeftOffset As Long ...
    (microsoft.public.vb.general.discussion)