PDF converter to xls

H

helmekki

Hello all

i have this code that converts xls files to PDF, but

my problem is is i donot have "Acrobat Distiller on Ne00" virtua
driver (which should be referenced to from vba mode) and how t
reference to it from vba mode.......

any idea is highly appreciated

before running the code, first you should do the following:
put in A1 this formula
R1C1(which is A1) ="C:\Documents and Settings\nh\M
Documents\"&C1&".ps"

and put in C1 this formula
C1=Automated Excel-to-PDF
which CELL REFERENCE C1 CONTAINS THE STRIPPED FILE NAME
then the code is:
Sub PDFconverter()
Dim PSFileName As String
Application.ActivePrinter = "Acrobat Distiller on Ne00:"
Application.Goto Reference:="r1c1"
Let PSFileName = Application.ActiveCell SendKeys PSFileName
"{ENTER}", False
ActiveSheet.PageSetup.PrintArea = "$A$1:$I$17" ActiveSheet.PrintOu
, PrintToFile:=True PSFileName = Chr(34) & PSFileName
Chr(34)
End Sub

yours
 
F

Frank Kabel

Hi
you have toi change this line with your Adobe driver from your printer
dialog. You'll need a PDF Writer at least installed a printer on your
system
 

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

Top