Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
From variable to excel constant
In an excel sheet I'm allowing users to pick from dropdown whether they want
to print in xlPortrait or xlLandscape. It's not feasible to go directly to Page setup because this page setup that we are applying is for another file. However, when I read this choice to a variable and setting pagesetup.orientation to this variable, it doesn't recognize it. This is because xlPortrait should not be a text, but a constant. Is there a formula to convert the string to constant? I must allow user to do the selection in the worksheet. Thanks, Carmen |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
From variable to excel constant
Try not to apply the text xlPortrait, but the integer of this
constant. xlPortrait = 1 xlLandscape = 2 hth Carlo On Dec 6, 11:11 am, Carmen wrote: In an excel sheet I'm allowing users to pick from dropdown whether they want to print in xlPortrait or xlLandscape. It's not feasible to go directly to Page setup because this page setup that we are applying is for another file. However, when I read this choice to a variable and setting pagesetup.orientation to this variable, it doesn't recognize it. This is because xlPortrait should not be a text, but a constant. Is there a formula to convert the string to constant? I must allow user to do the selection in the worksheet. Thanks, Carmen |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
From variable to excel constant
xlPortrait is a number and can't be treated as text.. This means it can't be
combined into a text string and can't be inside a double quoted string. It also can't be selectect be inside a textbox. You can do something like this From a drop down box put Portriat or Landscape select case Range("A1") 'or a textbox which has Portriat or Landscape case "Portrait" printmode = xlPortrait case "Landscape" printmode = xlLandscape end select pagesetup.orientation = printmode or select case Range("A1") 'or a textbox which has Portriat or Landscape case "Portrait" pagesetup.orientation = xlPortrait case "Landscape" pagesetup.orientation = xlLandscape end select The use printmode which is a number in your print command. "Carmen" wrote: In an excel sheet I'm allowing users to pick from dropdown whether they want to print in xlPortrait or xlLandscape. It's not feasible to go directly to Page setup because this page setup that we are applying is for another file. However, when I read this choice to a variable and setting pagesetup.orientation to this variable, it doesn't recognize it. This is because xlPortrait should not be a text, but a constant. Is there a formula to convert the string to constant? I must allow user to do the selection in the worksheet. Thanks, Carmen |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
subtract a variable no. of mos. from a constant date? in excel | Excel Discussion (Misc queries) | |||
How to average one constant # to variable #s? A1:A2 A1:A3 A1:A4 | Excel Worksheet Functions | |||
Variable Acting Like a Constant? | Excel Programming | |||
How to declare variable as Excel constant? | Excel Programming | |||
Excel application: Summing several terms (some constant, some variable) | Excel Programming |