PDA

View Full Version : Copy file to specific Folder and convert



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

daniels012
12-01-2008, 03:34 PM
ideas?

daniels012
12-02-2008, 08:30 AM
bump

daniels012
12-03-2008, 11:05 AM
bump

Dr.K
12-03-2008, 11:27 AM
Printing to PDF can be enormously complicated.

What is "PrimoPDF"? Is that a 3rd-party app?

If not, what version of Acrobat are you using?

RonMcK
12-03-2008, 11:35 AM
Michael,

It would help to select a type color that is easily readable. How about black?

Thanks,

daniels012
12-04-2008, 07:46 AM
Primo PDF is a 3rd party app.

RonMcK,
I am sorry about that!!

daniels012
12-04-2008, 07:47 AM
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:

Code:
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?

How is this RON?
Michael

RonMcK
12-04-2008, 07:55 AM
Michael,

That's fine. Another option (save for future reference) is to Edit your original message. This is helpful when you want to correct a posting or add additional detail to it.

Thanks,

daniels012
12-04-2008, 10:01 AM
ok,
What about my issue/question?

Michael