PageSetup Class

P Dev · 08-04-2005, 12:05 PM

I'm using the PageSetup class (late binding) in my application to set the
following.

ActiveSheet.PageSetup.Orientation = 2 ' Landscape
ActiveSheet.PageSetup.LeftMargin = 36
ActiveSheet.PageSetup.RightMargin = 36
ActiveSheet.PageSetup.TopMargin = 54
ActiveSheet.PageSetup.BottomMargin = 54
ActiveSheet.PageSetup.RightFooter = "Page &P of &N"

However, it depends on which environment I run the application as to whether
or not it works.

OS Excel Result
Windows XP Pro v2002 SP2 2003 (11.6355.6360) SP1 Always Works
Windows NT SP4 2003 (11.6355.6360) SP1 Does Not Work
Windows XP Pro v2002 SP2 2002 (10.6501.6735) SP3 Does Not Work

When it doesn't work, I receive the error message
"Unable to set the Orientation property of the PageSetup class"

If I comment out the Orientation property line, I receive the error message
"Unable to set the LeftMargin property of the PageSetup class"

Only when I comment out all the lines, will the application run without
error under the environments mentioned above.

Any ideas?

Bob Phillips · 08-04-2005, 01:05 PM

Maybe grabbing at straws a bit here, but check References in the VBE
(Tools>References), and if there are any, uncheck them.

--

HTH

RP
(remove nothere from the email address if mailing direct)

"P Dev" <[email protected]> wrote in message
news:[email protected]...
> I'm using the PageSetup class (late binding) in my application to set the
> following.
>
> ActiveSheet.PageSetup.Orientation = 2 ' Landscape
> ActiveSheet.PageSetup.LeftMargin = 36
> ActiveSheet.PageSetup.RightMargin = 36
> ActiveSheet.PageSetup.TopMargin = 54
> ActiveSheet.PageSetup.BottomMargin = 54
> ActiveSheet.PageSetup.RightFooter = "Page &P of &N"
>
> However, it depends on which environment I run the application as to
whether
> or not it works.
>
> OS Excel Result
> Windows XP Pro v2002 SP2 2003 (11.6355.6360) SP1 Always Works
> Windows NT SP4 2003 (11.6355.6360) SP1 Does Not Work
> Windows XP Pro v2002 SP2 2002 (10.6501.6735) SP3 Does Not Work
>
> When it doesn't work, I receive the error message
> "Unable to set the Orientation property of the PageSetup class"
>
> If I comment out the Orientation property line, I receive the error
message
> "Unable to set the LeftMargin property of the PageSetup class"
>
> Only when I comment out all the lines, will the application run without
> error under the environments mentioned above.
>
> Any ideas?
>

P Dev · 08-04-2005, 01:05 PM

I'm sorry, but I forgot to clarify that this is a VB.Net application.

"Bob Phillips" wrote:

> Maybe grabbing at straws a bit here, but check References in the VBE
> (Tools>References), and if there are any, uncheck them.
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "P Dev" <[email protected]> wrote in message
> news:[email protected]...
> > I'm using the PageSetup class (late binding) in my application to set the
> > following.
> >
> > ActiveSheet.PageSetup.Orientation = 2 ' Landscape
> > ActiveSheet.PageSetup.LeftMargin = 36
> > ActiveSheet.PageSetup.RightMargin = 36
> > ActiveSheet.PageSetup.TopMargin = 54
> > ActiveSheet.PageSetup.BottomMargin = 54
> > ActiveSheet.PageSetup.RightFooter = "Page &P of &N"
> >
> > However, it depends on which environment I run the application as to
> whether
> > or not it works.
> >
> > OS Excel Result
> > Windows XP Pro v2002 SP2 2003 (11.6355.6360) SP1 Always Works
> > Windows NT SP4 2003 (11.6355.6360) SP1 Does Not Work
> > Windows XP Pro v2002 SP2 2002 (10.6501.6735) SP3 Does Not Work
> >
> > When it doesn't work, I receive the error message
> > "Unable to set the Orientation property of the PageSetup class"
> >
> > If I comment out the Orientation property line, I receive the error
> message
> > "Unable to set the LeftMargin property of the PageSetup class"
> >
> > Only when I comment out all the lines, will the application run without
> > error under the environments mentioned above.
> >
> > Any ideas?
> >
>
>
>

Bob Phillips · 08-04-2005, 01:05 PM

Then I'm outa here I am afraid :-)

Bob

"P Dev" <[email protected]> wrote in message
news:[email protected]...
> I'm sorry, but I forgot to clarify that this is a VB.Net application.
>
> "Bob Phillips" wrote:
>
> > Maybe grabbing at straws a bit here, but check References in the VBE
> > (Tools>References), and if there are any, uncheck them.
> >
> > --
> >
> > HTH
> >
> > RP
> > (remove nothere from the email address if mailing direct)
> >
> >
> > "P Dev" <[email protected]> wrote in message
> > news:[email protected]...
> > > I'm using the PageSetup class (late binding) in my application to set
the
> > > following.
> > >
> > > ActiveSheet.PageSetup.Orientation = 2 ' Landscape
> > > ActiveSheet.PageSetup.LeftMargin = 36
> > > ActiveSheet.PageSetup.RightMargin = 36
> > > ActiveSheet.PageSetup.TopMargin = 54
> > > ActiveSheet.PageSetup.BottomMargin = 54
> > > ActiveSheet.PageSetup.RightFooter = "Page &P of &N"
> > >
> > > However, it depends on which environment I run the application as to
> > whether
> > > or not it works.
> > >
> > > OS Excel Result
> > > Windows XP Pro v2002 SP2 2003 (11.6355.6360) SP1 Always Works
> > > Windows NT SP4 2003 (11.6355.6360) SP1 Does Not Work
> > > Windows XP Pro v2002 SP2 2002 (10.6501.6735) SP3 Does Not Work
> > >
> > > When it doesn't work, I receive the error message
> > > "Unable to set the Orientation property of the PageSetup class"
> > >
> > > If I comment out the Orientation property line, I receive the error
> > message
> > > "Unable to set the LeftMargin property of the PageSetup class"
> > >
> > > Only when I comment out all the lines, will the application run
without
> > > error under the environments mentioned above.
> > >
> > > Any ideas?
> > >
> >
> >
> >

NickHK · 08-04-2005, 10:05 PM

No idea about .Net
But does the code work in VBA on all the OS's ?
At least narrow it down to culprit.

NickHK

"P Dev" <[email protected]> wrote in message
news:[email protected]...
> I'm sorry, but I forgot to clarify that this is a VB.Net application.
>
> "Bob Phillips" wrote:
>
> > Maybe grabbing at straws a bit here, but check References in the VBE
> > (Tools>References), and if there are any, uncheck them.
> >
> > --
> >
> > HTH
> >
> > RP
> > (remove nothere from the email address if mailing direct)
> >
> >
> > "P Dev" <[email protected]> wrote in message
> > news:[email protected]...
> > > I'm using the PageSetup class (late binding) in my application to set
the
> > > following.
> > >
> > > ActiveSheet.PageSetup.Orientation = 2 ' Landscape
> > > ActiveSheet.PageSetup.LeftMargin = 36
> > > ActiveSheet.PageSetup.RightMargin = 36
> > > ActiveSheet.PageSetup.TopMargin = 54
> > > ActiveSheet.PageSetup.BottomMargin = 54
> > > ActiveSheet.PageSetup.RightFooter = "Page &P of &N"
> > >
> > > However, it depends on which environment I run the application as to
> > whether
> > > or not it works.
> > >
> > > OS Excel Result
> > > Windows XP Pro v2002 SP2 2003 (11.6355.6360) SP1 Always Works
> > > Windows NT SP4 2003 (11.6355.6360) SP1 Does Not Work
> > > Windows XP Pro v2002 SP2 2002 (10.6501.6735) SP3 Does Not Work
> > >
> > > When it doesn't work, I receive the error message
> > > "Unable to set the Orientation property of the PageSetup class"
> > >
> > > If I comment out the Orientation property line, I receive the error
> > message
> > > "Unable to set the LeftMargin property of the PageSetup class"
> > >
> > > Only when I comment out all the lines, will the application run
without
> > > error under the environments mentioned above.
> > >
> > > Any ideas?
> > >
> >
> >
> >

P Dev · 08-22-2005, 02:05 PM

For anyone who's interested, the problem ended up being that the computers
where the code did not work, did not have a default printer set up. Once a
default printer was added, the code worked fine!

"P Dev" wrote:

> I'm sorry, but I forgot to clarify that this is a VB.Net application.
>
> "Bob Phillips" wrote:
>
> > Maybe grabbing at straws a bit here, but check References in the VBE
> > (Tools>References), and if there are any, uncheck them.
> >
> > --
> >
> > HTH
> >
> > RP
> > (remove nothere from the email address if mailing direct)
> >
> >
> > "P Dev" <[email protected]> wrote in message
> > news:[email protected]...
> > > I'm using the PageSetup class (late binding) in my application to set the
> > > following.
> > >
> > > ActiveSheet.PageSetup.Orientation = 2 ' Landscape
> > > ActiveSheet.PageSetup.LeftMargin = 36
> > > ActiveSheet.PageSetup.RightMargin = 36
> > > ActiveSheet.PageSetup.TopMargin = 54
> > > ActiveSheet.PageSetup.BottomMargin = 54
> > > ActiveSheet.PageSetup.RightFooter = "Page &P of &N"
> > >
> > > However, it depends on which environment I run the application as to
> > whether
> > > or not it works.
> > >
> > > OS Excel Result
> > > Windows XP Pro v2002 SP2 2003 (11.6355.6360) SP1 Always Works
> > > Windows NT SP4 2003 (11.6355.6360) SP1 Does Not Work
> > > Windows XP Pro v2002 SP2 2002 (10.6501.6735) SP3 Does Not Work
> > >
> > > When it doesn't work, I receive the error message
> > > "Unable to set the Orientation property of the PageSetup class"
> > >
> > > If I comment out the Orientation property line, I receive the error
> > message
> > > "Unable to set the LeftMargin property of the PageSetup class"
> > >
> > > Only when I comment out all the lines, will the application run without
> > > error under the environments mentioned above.
> > >
> > > Any ideas?
> > >
> >
> >
> >