Print Page Set up

  • Thread starter Thread starter playerbigdog
  • Start date Start date
P

playerbigdog

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?
 
Maybe, if you change "YEARS2" to "PrintReports2" in the Workbooks.Open
statement it will work.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Code corrupts file (XL2003) 3
How do I add the ability to select the number of printed pages to aDialog Sheet 2
Range Object being "forgotten" 1
VBA in module vs slide 4
Printing from Windows XP on a USB printer connected to Windows 0
Problem Printing objects from web page 7
Let's discuss XP memory management (paging, pagfile, etc.) 2
Export to Excel: 2nd, 3rd, etc excel files not opening up 7

Back
Top