daniels012
11-26-2008, 01:11 PM
I want to click a button and add code to do the following:
I have a file called
"Proposal in XL"
I want to copy it to a folder
"C:\Emailed Proposals\"
using this to give it's name:
Range("C6").Value & Range("O3").Value & ".xls"
Then I need to change it to PDF (or make it PDF and delete the Excel File)
Maybe something like this:
Application.ActivePrinter = "PrimoPDF on Ne00:"
ActiveWindow.SelectedSheets.PrintOut Copies:=1, ActivePrinter:= _
"PrimoPDF on Ne00:", Collate:=True
Then change the printer back:
Application.ActivePrinter = "EPSON Stylus C86 Series on Ne02:"
And Keep the "Proposal for XL" file open
Is this impossible?
Michael
I have a file called
"Proposal in XL"
I want to copy it to a folder
"C:\Emailed Proposals\"
using this to give it's name:
Range("C6").Value & Range("O3").Value & ".xls"
Then I need to change it to PDF (or make it PDF and delete the Excel File)
Maybe something like this:
Application.ActivePrinter = "PrimoPDF on Ne00:"
ActiveWindow.SelectedSheets.PrintOut Copies:=1, ActivePrinter:= _
"PrimoPDF on Ne00:", Collate:=True
Then change the printer back:
Application.ActivePrinter = "EPSON Stylus C86 Series on Ne02:"
And Keep the "Proposal for XL" file open
Is this impossible?
Michael