Prev: Unix Command - cp -p
Next: SAS on Mainframe
From: Mark Sussman on 17 Nov 2009 18:27
Trying to use DDE to format an Excel spreadsheet and want to select
the option in scaling "Fit to: 1 page(s) wide by ' ' tall" using
Page.setup.

This is my current code without an option selected for scaling:

[Page.Setup(" "," ", 0.75,0.75,1,1,False,False,True,False,1,1)]

From: Arthur Tabachneck on 17 Nov 2009 18:55
Mark,

The following is from the paper shown below:

/* landscape page setup with fit to page */
/* and center horizontally options specified */
put '[Page.Setup(" "," ",0.75,0.75,1,1,False,
False,True,False,2,1,True,1,1,False)]';
Parameters are:
head, foot,
left-, right-, top-, bottom- margins,
heading, grid, horizontal center, vertical center,
orientation, paper size, scale, page number,
page order, cell color

http://www.nesug.org/Proceedings/nesug02/ad/ad007.pdf

HTH,
Art
----------
On Tue, 17 Nov 2009 15:27:23 -0800, Mark Sussman <msussman(a)GMAIL.COM> wrote:

>Trying to use DDE to format an Excel spreadsheet and want to select
>the option in scaling "Fit to: 1 page(s) wide by ' ' tall" using
>Page.setup.
>
>This is my current code without an option selected for scaling:
>
>[Page.Setup(" "," ", 0.75,0.75,1,1,False,False,True,False,1,1)]
From: Mark Sussman on 17 Nov 2009 19:05
On Nov 17, 6:55 pm, art...(a)NETSCAPE.NET (Arthur Tabachneck) wrote:
> Mark,
>
> The following is from the paper shown below:
>
> /* landscape page setup with fit to page */
> /* and center horizontally options specified */
> put '[Page.Setup(" "," ",0.75,0.75,1,1,False,
> False,True,False,2,1,True,1,1,False)]';
> Parameters are:
> head, foot,
> left-, right-, top-, bottom- margins,
> heading, grid, horizontal center, vertical center,
> orientation, paper size, scale, page number,
> page order, cell color
>
> http://www.nesug.org/Proceedings/nesug02/ad/ad007.pdf
>
> HTH,
> Art
> ----------
>
> On Tue, 17 Nov 2009 15:27:23 -0800, Mark Sussman <msuss...(a)GMAIL.COM> wrote:
> >Trying to use DDE to format an Excel spreadsheet and want to select
> >the option in scaling "Fit to:  1 page(s) wide by  '  ' tall" using
> >Page.setup.
>
> >This is my current code without an option selected for scaling:
>
> >[Page.Setup(" "," ", 0.75,0.75,1,1,False,False,True,False,1,1)]

Hey Art,

I based my code off that paper, but that code fits to 1 page on matter
how many rows are in your data. I'm looking to modify that code in
order to fit 1 page wide and auto fiting the pages long.

Thanks for the response though

Mark
 | 
Pages: 1
Prev: Unix Command - cp -p
Next: SAS on Mainframe