| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Print Page Set up
Title3 = "What year would you like to print"
PrintReports2 = InputBox(Message3, Title3, "EnterYear") EnterYear = "YEARS2" If PrintCharts = "" Then cancel = "1" EnterYear = "YEARS2" Else cancel = "0" EnterYear = "YEARS2" End If Workbooks.Open Filename:="C:\PF Test\" + "PF Assessment " + YEARS2 + "\All Members\" + myVar1 + ".xlsx" Sheets(myVar1).Select I want this code to allow me to have what year enterd into the "EnterYear" spot saved under YEARS2. Any suggestions? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Print Page Set up
Maybe, if you change "YEARS2" to "PrintReports2" in the Workbooks.Open
statement it will work. "playerbigdog" wrote: Title3 = "What year would you like to print" PrintReports2 = InputBox(Message3, Title3, "EnterYear") EnterYear = "YEARS2" If PrintCharts = "" Then cancel = "1" EnterYear = "YEARS2" Else cancel = "0" EnterYear = "YEARS2" End If Workbooks.Open Filename:="C:\PF Test\" + "PF Assessment " + YEARS2 + "\All Members\" + myVar1 + ".xlsx" Sheets(myVar1).Select I want this code to allow me to have what year enterd into the "EnterYear" spot saved under YEARS2. Any suggestions? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Print Page Set up
Hey i think that is going to work. Thanks for the quick fix.
"TomPl" wrote: Maybe, if you change "YEARS2" to "PrintReports2" in the Workbooks.Open statement it will work. "playerbigdog" wrote: Title3 = "What year would you like to print" PrintReports2 = InputBox(Message3, Title3, "EnterYear") EnterYear = "YEARS2" If PrintCharts = "" Then cancel = "1" EnterYear = "YEARS2" Else cancel = "0" EnterYear = "YEARS2" End If Workbooks.Open Filename:="C:\PF Test\" + "PF Assessment " + YEARS2 + "\All Members\" + myVar1 + ".xlsx" Sheets(myVar1).Select I want this code to allow me to have what year enterd into the "EnterYear" spot saved under YEARS2. Any suggestions? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do you print single page multiply times with increasing page . | Excel Worksheet Functions | |||
| Setting the print area in page set up to print 1 page wide by 2 pages tall | Excel Discussion (Misc queries) | |||
| PRINT PAGE BREAK VIEW AS WATERMARK FIOR EACH PAGE | Setting up and Configuration of Excel | |||
| Active cell counting in particular print page (one sheet having different print area) | Excel Worksheet Functions | |||
| How do I print a one page spreadsheet multiple time, each with its own page number? | Excel Discussion (Misc queries) | |||
Linear Mode
