moneytastesbad
Board Regular
- Joined
- Aug 28, 2006
- Messages
- 106
Hello,
I know that this is everyones favorite subject
What I need to do is convert a single sheet in my workbook to PDF using Primo PDF, ans save that (the PDF) to a File Path and Folder specified within a cell in the workbook.
Here is what I have so far:
A
I modified the code that I found here http://www.mrexcel.com/board2/viewtopic.php?t=234661 to come up with what I have now.
However, this does not seem to be working for me. All I am doing is printing via Primo PDF( converting to PDF). It is not saving the file where I specified. It is asking me where I want to save it to.
Can anyone Help me please?!?!?!?
I know that this is everyones favorite subject
What I need to do is convert a single sheet in my workbook to PDF using Primo PDF, ans save that (the PDF) to a File Path and Folder specified within a cell in the workbook.
Here is what I have so far:
A
Code:
ctiveWorkbook.Save
Path = Application.Range("FilePath").Value
Folder = Application.Range("ProgramName").Value
File = Application.Range("ProgramName").Value
On Error Resume Next
ActiveWorkbook.SaveAs Filename:= _
Path & Folder & "\" & File, FileFormat:=xlNormal _
, Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, _
CreateBackup:=False
On Error GoTo 0
Application.ActivePrinter = "PrimoPDF on Ne00:"
ActiveWindow.SelectedSheets.PrintOut Copies:=1, ActivePrinter:= _
"PrimoPDF on Ne00:", Collate:=True
I modified the code that I found here http://www.mrexcel.com/board2/viewtopic.php?t=234661 to come up with what I have now.
However, this does not seem to be working for me. All I am doing is printing via Primo PDF( converting to PDF). It is not saving the file where I specified. It is asking me where I want to save it to.
Can anyone Help me please?!?!?!?