| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
PageSetup Class
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
PageSetup Class
Maybe grabbing at straws a bit here, but check References in the VBE
(ToolsReferences), and if there are any, uncheck them. -- HTH RP (remove nothere from the email address if mailing direct) "P Dev" wrote in message ... 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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
PageSetup Class
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 (ToolsReferences), and if there are any, uncheck them. -- HTH RP (remove nothere from the email address if mailing direct) "P Dev" wrote in message ... 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? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
PageSetup Class
Then I'm outa here I am afraid :-)
Bob "P Dev" wrote in message ... 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 (ToolsReferences), and if there are any, uncheck them. -- HTH RP (remove nothere from the email address if mailing direct) "P Dev" wrote in message ... 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? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
PageSetup Class
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" wrote in message ... 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 (ToolsReferences), and if there are any, uncheck them. -- HTH RP (remove nothere from the email address if mailing direct) "P Dev" wrote in message ... 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? |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
PageSetup Class
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 (ToolsReferences), and if there are any, uncheck them. -- HTH RP (remove nothere from the email address if mailing direct) "P Dev" wrote in message ... 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? |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
PageSetup Class
Thank you so much for the reply! It saved me in a very critical situation :)
Cheers, Ajith Kumar |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
PageSetup Class
Thanks a zillion ton!
We had similar problem since months, now rectified! url:http://www.ureader.com/msg/103711516.aspx |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
PageSetup Class
Thanks from me too. This problem was driving me crazy - the code worked on
one computer but never on another. This fixed it. url:http://www.ureader.com/msg/103711516.aspx |
|
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
PageSetup Class
Hi -
I have the EXACT same problem and is driving me NUTS. I copied the URL below that "worked" for you and another person and I just go back to the same posting. What was the actual fix? THe URL below just brings me back to the original post: http://www.ureader.com/msg/103711516.aspx url:http://www.ureader.com/msg/103711516.aspx |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help - Error: Unable to set the PrintArea property of the PageSetup class | Excel Programming | |||
| Unable to set the PaperSize property of the PageSetup class | Excel Programming | |||
| Unable to Set LeftFooter Property Class PageSetup (ASP) | Excel Programming | |||
| Unable to set the PrintQuality property of the PageSetup class. | Excel Programming | |||
| RaiseEvent from a class contained in a 2nd class collection? | Excel Programming | |||
Linear Mode
