Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error 1004 - unable to set the orientation of the page setup class
Hi,
I have a VB6 programming accessing excel. I had previously had no trouble setting the orientation of the sheet but now that I have a windows xp, I am getting the above error. I have Office 97 installed on my machine. thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error 1004 - unable to set the orientation of the page setup class
Do you have a valid reference to the Excel application in Tools=References.
It is possible that you don't. If you are are talking about printing out orientation portrait or landscape, the constants are ? xlLandscape 2 ? xlPortrait 1 But I the weren't defined (no reference to the excel object library), they would be seen as a value of Zero which would probably raise the error you describe. -- Regards, Tom Ogilvy "E Sullivan" wrote in message ... Hi, I have a VB6 programming accessing excel. I had previously had no trouble setting the orientation of the sheet but now that I have a windows xp, I am getting the above error. I have Office 97 installed on my machine. thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error 1004 - unable to set the orientation of the page setup class
I have the reference to the excel 8 object library so I guess that's not it.
"Tom Ogilvy" wrote in message ... Do you have a valid reference to the Excel application in Tools=References. It is possible that you don't. If you are are talking about printing out orientation portrait or landscape, the constants are ? xlLandscape 2 ? xlPortrait 1 But I the weren't defined (no reference to the excel object library), they would be seen as a value of Zero which would probably raise the error you describe. -- Regards, Tom Ogilvy "E Sullivan" wrote in message ... Hi, I have a VB6 programming accessing excel. I had previously had no trouble setting the orientation of the sheet but now that I have a windows xp, I am getting the above error. I have Office 97 installed on my machine. thanks |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error 1004 - unable to set the orientation of the page setup class
E, is the default printer set to a printer that allows the orientation to be
changed? I've run into the problem before when the default printer is the not the one I thought it was... Bob Flanagan Macro Systems http://www.add-ins.com Productivity add-ins and downloadable books on VB macros for Excel "E Sullivan" wrote in message ... Hi, I have a VB6 programming accessing excel. I had previously had no trouble setting the orientation of the sheet but now that I have a windows xp, I am getting the above error. I have Office 97 installed on my machine. thanks |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error 1004 - unable to set the orientation of the page setup class
I think I figured it out. I'm not attached to a printer. In regular excel, I
can't open the page setup because of that so that is what I'm guessing. It's not easy for me right now to attach to a printer and this code has been working for years, so I'm just going to trap the error and move on. "Tom Ogilvy" wrote in message ... Do you have a valid reference to the Excel application in Tools=References. It is possible that you don't. If you are are talking about printing out orientation portrait or landscape, the constants are ? xlLandscape 2 ? xlPortrait 1 But I the weren't defined (no reference to the excel object library), they would be seen as a value of Zero which would probably raise the error you describe. -- Regards, Tom Ogilvy "E Sullivan" wrote in message ... Hi, I have a VB6 programming accessing excel. I had previously had no trouble setting the orientation of the sheet but now that I have a windows xp, I am getting the above error. I have Office 97 installed on my machine. thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Run-time error '1004': AutoFill method of Range class failed | Excel Discussion (Misc queries) | |||
Error 1004 Copy method of worksheet class failed | Excel Discussion (Misc queries) | |||
R/T 1004 - Unable to get Button prop of Ws Class | Excel Discussion (Misc queries) | |||
error 1004 Select method of Range class failed | Excel Programming | |||
error 1004 - metod Copy of class Range was failed | Excel Programming |