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.
|Published (Last):||21 April 2009|
|PDF File Size:||8.80 Mb|
|ePub File Size:||1.58 Mb|
|Price:||Free* [*Free Regsitration Required]|
Here’s some more background on why and what I am trying to do:. Same operating system, same everything, so I’m not sure what the issue is with making a activeprintter local port. When it asks you for a printer, select Apple LaserWriter Pro and actjveprinter the printer installation. There is probably a parameter to use.
To start viewing messages, select the forum that you want to visit from the selection below.
VBA Visual Basic for Applications (Microsoft) FAQ
set default printer to Adobe PDF (/XP) | Windows Secrets Lounge
If I click on that I can create a pdf and save it as temp. My macro to date is below, but everything I’ve tried so far results in a. ActivePrinter applicatiob save whatever printer the user was printing on and reset it afterward, but Application. 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: Login or Sign Up.
Place Excel into table with ability to link when native Excel file is updated.
Sorry, I have no idea applicaton it doesn’t work, but do try it with a local file name. But that won’t make a PDF.
It seems to work fine as long as you don’t include the PrToFileName: That’s what I’m trying to do via a macro. The above FAQ links open in a new window. I dont have a list combo. This is driving me nuts!
Creating PDF File from Excel using VBA Script – Adobe Acrobat Windows
If so then that explains why you were not able to print to PS – I thought you were doing it manually! Please type your message and try again. Is the file you are editing a PostScript file?
If this is your first visit, be sure to check out the Board FAQ by clicking the link above. The trick is to do the send key first, thereby putting it into the buffer.
What is acgiveprinter full command line you used with the parameters for printing to file? I just had to dig a little deeper in the thread. The file I am working with is a. Results 1 to 10 of Page 1 of 2 1 2 Last Jump to page: Help finding Active printer “on Ne02” to get all the available printers with ports into a appplication box or array Code:.
Page 1 of 2 1 2 Last Jump to page: The time now is Become a Registered Member free to remove the ad that appears in the top post.
Well, I need to accomplish this via a macro.