The only one I need with Acrobat 6.0 is the Acrobat Distiller reference.
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
The problem I think is with this piece of code:
Also - it is still printing on my default printer and not the pdf..... any ideas?mypdfDist.FileToPDF tempPSFileName, tempPDFFileName, ""
Any ides on the code:
I think I might be getting something mixed up here:Sub Create_PDF(wsPrint_Sheet As Worksheet) 'Dom Hill, June 2008 'This code has only been tested with Adobe Acrobat 6.0 Professional 'For this code to work the Adobe Distiller VBA library must be enabled 'Select Tools...References in the VBA editor and check it from the list Dim tempPDFFileName As String Dim tempPSFileName As String Dim tempPDFRawFileName As String Dim tempLogFileName As String tempPDFRawFileName = "C:\" & wsPrint_Sheet.Name tempPSFileName = tempPDFRawFileName & ".ps" tempPDFFileName = tempPDFRawFileName & ".pdf" tempLogFileName = tempPDFRawFileName & ".log" 'Prints worksheet as a pdf wsPrint_Sheet.PrintOut Copies:=1, preview:=False, ActivePrinter:= _ "Acrobat Distiller on Ne03:", printtofile:=True, Collate:=True, prtofilename:=tempPSFileName Dim mypdfDist As New PdfDistiller mypdfDist.FileToPDF tempPSFileName, tempPDFFileName, "" Kill tempPSFileName Kill tempLogFileName End Sub
wsPrint_Sheet.PrintOut Copies:=1, preview:=False, ActivePrinter:= _ "Acrobat Distiller on Ne03:", printtofile:=True, Collate:=True, prtofilename:=tempPSFileName
Looks fine but I've still no idea if it will work in Adobe 5.0. I'm guessing not from the problems you're having.
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
OK - how about PDF Creator. Do you know if this would work for that? what changes would I need here... thanks
Never had cause to use it myself but all the info is there on the link that Roy posted.
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
I have just run it again and this time i get the following error:
Run-time error 429
ActiveX component can’t create object
any ideas?
How is that different from the above error you were getting the other day?Originally Posted by omarq
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
ahhh -sorry. i've been looking at this for so long i'm getting fish for brains. apologies
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks