Printer = “Adobe PDF on Ne” edSheets .PrintOut Copies:=1, ActivePrinter:= _ “Adobe PDF on Ne”. Private Sub cmdMakePDF_Click() Dim Msg As String On Error GoTo MakePDFError: Printer = “Adobe PDF on Ne”. Problem is the Adobe part. I can use Printer to save whatever printer the user was printing on and reset it afterward, but.

Author: Kajirr Akimi
Country: Bulgaria
Language: English (Spanish)
Genre: Software
Published (Last): 28 January 2006
Pages: 44
PDF File Size: 2.72 Mb
ePub File Size: 18.23 Mb
ISBN: 119-5-31644-639-4
Downloads: 3435
Price: Free* [*Free Regsitration Required]
Uploader: Groran

VBA Visual Basic for Applications (Microsoft) FAQ

Here is a sample PS file you can distill: Here’s where my VBA skills get stuck. Does anyone know if i should replace the bottom strip of code with the top and also, i get a variable not defined on the top code for reg and regvalue. Here’s some more background on why and what I am trying to do:. When it asks you for a printer, select Apple LaserWriter Pro and finish the printer installation.

We always have to do several PDF for the same excel file.

I had used the PrintOut command with Acrobat 5. This program is using OLE to open Word documents, add watersmarks and other details, then save the changed Word doc as a appplication to c: Then name the port C: Help finding Active printer “on Ne02” does this help http: I turned it into a little function, which works great: By continuing to use our website, you agree to the use of such cookies.


But if you don’t put that in, you’ll be prompted for a filename everytime; kind of defeats applocation purpose of automation.

It seems to work fine as long as you don’t include the PrToFileName: This works fine on my machine with Acrobat 5. Any ideas on how to fully automate the creation of the PS file?

Creating PDF File from Excel using VBA Script – Adobe Acrobat Windows

Additionally, in some cases, an additional Word doc is created on the applicaiton which must also be saved as C: I would simply use the following code and tell the user to select the PDF printer. Correct Answers – 10 points.

Help Contact Us Go to top. To do this you have to: The problem with Excel is that we cannot convert a excel file including several sheets.

I’ve been trying to create a macro for Word documents that will write the document out as a PDF and named as C: Aandi, can you help me?

When Applicqtion distribute the code to other users their Adobe printer might be associated with “Ne01” causing an error. Please enter a title. The resulting file gets named C: This doesn’t work either, and I am getting frustrated.

Alternatively, I suppose I could export the registry to a text file and do a search, but that seems like a very inelegant solution.


We process personal data about users of our site, through the use of cookies and other technologies, to deliver our services, personalize advertising, and to analyze site activity. Now you should have the printer setup locally on applicatiin pc.


My macro to date is below, but everything I’ve tried so far results in a. Help finding Active printer “on Ne02” the bottom code writes a line to the registry, which is unlikely to do what you want what it does is to set the file name for the next file to be printed by the acrobat pdf printer driver, this does not affect the port the pdf driver is on. I know that i also write in the french forum for the same topic but is to have best chance to solve my problem o: Help finding Active printer “on Ne02” no, ne02 may already be in use when they install pdf driver but you can use a cut down activeprinrer of the above code like this Code: Place Excel into table with ability to link when native Excel file is updated.