doPDF Forum Tag: VBA

doPDF Forum Tag: VBA http://www.dopdf.com/forum/ Discussion forum for doPDF users. en Wed, 08 Feb 2012 21:15:00 +0000 Softland on "VBA in Excel" http://www.dopdf.com/forum/topic/vba-in-excel#post-4714 Thu, 10 Nov 2011 13:39:11 +0000 Softland 4714@http://www.dopdf.com/forum/ As explained in the upper posts, no, unfortunately we cannot. golly on "VBA in Excel" http://www.dopdf.com/forum/topic/vba-in-excel#post-4713 Thu, 10 Nov 2011 13:31:01 +0000 golly 4713@http://www.dopdf.com/forum/ It doesn't matter. You can't help me. Softland on "VBA in Excel" http://www.dopdf.com/forum/topic/vba-in-excel#post-4712 Wed, 09 Nov 2011 14:20:05 +0000 Softland 4712@http://www.dopdf.com/forum/ Hi, The post contained links towards 3rd party websites so it was treated as spam and removed automatically because it was not linked correctly in the post. Thank you for understanding. golly on "VBA in Excel" http://www.dopdf.com/forum/topic/vba-in-excel#post-4711 Wed, 09 Nov 2011 13:12:46 +0000 golly 4711@http://www.dopdf.com/forum/ You are unfriendly. You don't want help. You delete my posts. goodbye you goodbye your software golly Softland on "VBA in Excel" http://www.dopdf.com/forum/topic/vba-in-excel#post-4709 Wed, 09 Nov 2011 07:59:46 +0000 Softland 4709@http://www.dopdf.com/forum/ Hello, Unfortunately we do not provide development support for additional samples. Thank you. golly on "VBA in Excel" http://www.dopdf.com/forum/topic/vba-in-excel#post-4708 Tue, 08 Nov 2011 15:32:34 +0000 golly 4708@http://www.dopdf.com/forum/ Hello, Thank you for quick answer. I'm not developer so I don't understand SDK version ;/ Could you create any sample for us ? Best regards golly Softland on "VBA in Excel" http://www.dopdf.com/forum/topic/vba-in-excel#post-4707 Tue, 08 Nov 2011 15:23:57 +0000 Softland 4707@http://www.dopdf.com/forum/ Hello, Unfortunately we do not have a VBA sample for Excel to use with doPDF. For developers there is a SDK version you could try at <a href="http://www.novapdf.com/en/pdf-sdk.html" rel="nofollow">http://www.novapdf.com/en/pdf-sdk.html</a> , version that also contains various samples of code that may be of use to you. Thank you for understanding. golly on "VBA in Excel" http://www.dopdf.com/forum/topic/vba-in-excel#post-4706 Tue, 08 Nov 2011 13:06:41 +0000 golly 4706@http://www.dopdf.com/forum/ Hello, I would like to use doPDF to create pdf files from Excel 2003 by VBA. Could you show me any example of using doPDF do print to pdf by VBA? Best regards Tomesz Softland on "Folder Problems" http://www.dopdf.com/forum/topic/folder-problems#post-4215 Fri, 04 Mar 2011 08:37:59 +0000 Softland 4215@http://www.dopdf.com/forum/ Hello, Please send us the XLS file with the macros to <a href="mailto:support@novapdf.com">support@novapdf.com</a> so we can troubleshoot this further. Thank you. Franco403 on "Folder Problems" http://www.dopdf.com/forum/topic/folder-problems#post-4213 Thu, 03 Mar 2011 15:40:49 +0000 Franco403 4213@http://www.dopdf.com/forum/ Since updating my DoPDF software to ver7 from ver6 the VBA macro I wrote to print an Excel file into a specific folder will no longer work: ___________________________________________________________________________________ Sub Printing() ' ' Printing Macro ' 'Print the file in PDF format ChDrive "z" ChDir "\Invoices \Statements\PDF\" Application.ActivePrinter = "doPDF v6 on DOP6:” ExecuteExcel4Macro "PRINT(1,,,1,,,,,,,,2,""doPDF v6 on DOP6:"",,,,FALSE)" End Sub ___________________________________________________________________________________ This works perfectly, if you accept the default location the file will be created in the folder “Z:\Invoices\Statements\PDF\” exactly as I wish. However if the macro is changed to use ver7: ___________________________________________________________________________________ Sub Printing() ' ' Printing Macro ' 'Print the file in PDF format ChDrive "z" ChDir "\Invoices\Statements\PDF\" Application.ActivePrinter = "doPDF v7 on DOP7:" ExecuteExcel4Macro "PRINT(1,,,1,,,,,,,,2,""doPDF v7 on DOP7:"",,,,FALSE)" End Sub _____________________________________________________________________________________ The default folder location is “E:\My Documents”. For this reason I still use ver6 for VBA printing and ver7 for manual conversion. Does anyone know if I can fix this problem please or is it a limitation of the new version? Softland on "VB EXCEL pour e" http://www.dopdf.com/forum/topic/vb-excel-pour-e#post-3790 Fri, 03 Sep 2010 07:56:25 +0000 Softland 3790@http://www.dopdf.com/forum/ Hello, I am afraid we do not have a sample code for Visual Basic at this time. Thank you. DBOUCHET on "VB EXCEL pour e" http://www.dopdf.com/forum/topic/vb-excel-pour-e#post-3786 Thu, 02 Sep 2010 21:26:06 +0000 DBOUCHET 3786@http://www.dopdf.com/forum/ Bonsoir je recherche une macro vba pour convertir un fichier .xls en pdf avec DOPDF. Merci d'avance Softland on "Need VB Code to print with doPDF" http://www.dopdf.com/forum/topic/need-vb-code-to-print-with-dopdf#post-3735 Mon, 16 Aug 2010 07:09:27 +0000 Softland 3735@http://www.dopdf.com/forum/ Hello, This operation is possible however i am afraid we cannot provide you with a sample for your conversion. Thank you for understanding. emailmaomao on "Need VB Code to print with doPDF" http://www.dopdf.com/forum/topic/need-vb-code-to-print-with-dopdf#post-3720 Fri, 06 Aug 2010 23:16:08 +0000 emailmaomao 3720@http://www.dopdf.com/forum/ Hi all, I am generating multiple packing lists within excel (on single sheet*), my boss would like those to be printed as PDF. Anyone knows if I can VBa /macro to print within excel? The reason why I can't do it manually because single packing list will be generated one at a time, then send to PDF creator to print as file, then move on to next one.. I have successfully created this with another pdf software ("PDFCreator") but the problem is when I copy & paste the text within the pdf file, the character turns into weird symbols. Note: on single sheet* Processes: create single packing list on sheet "X" > print as PDF > create next single packing list > print as PDF till end of orders. Thanks ahead! AM. Softland on "Create PDF File Name from VBA" http://www.dopdf.com/forum/topic/create-pdf-file-name-from-vba#post-1014 Tue, 29 Sep 2009 06:14:24 +0000 Softland 1014@http://www.dopdf.com/forum/ This is possible in novapdf only for now, i've tagged this for the wishlist. richlocus on "Create PDF File Name from VBA" http://www.dopdf.com/forum/topic/create-pdf-file-name-from-vba#post-1011 Fri, 25 Sep 2009 22:13:44 +0000 richlocus 1011@http://www.dopdf.com/forum/ I just saw the post that it can't be done... this is one for my wish list. Thanks. richlocus on "Create PDF File Name from VBA" http://www.dopdf.com/forum/topic/create-pdf-file-name-from-vba#post-1010 Fri, 25 Sep 2009 19:19:06 +0000 richlocus 1010@http://www.dopdf.com/forum/ Hello doPDF Community: I am trying to create a PDF file with the doPDF V6 printer application, but I would like to specify the output file name and path from VBA in Excel or Microsoft Access and not have doPDF ask for any user input. Is that possible? Is there a VBA interface or API? Regards, Rich Locus Logicwurks, LLC logicwurks.com Softland on "Excel VBA and doPDF" http://www.dopdf.com/forum/topic/excel-vba-and-dopdf#post-95 Wed, 18 Jun 2008 07:50:01 +0000 Softland 95@http://www.dopdf.com/forum/ Sorry but not from the code directly. Normally another parameter should set the name automatically, prtofilename:="c:\test.pdf", but since that also requires to set a path it's not supported (it would mean bypassing the save as window). However, note that doPDF always prints the pdf with a filename that's actually the name of the opened workbook, so you'll simply have to name your workbook the way you want it shown in the PDF. Candu on "Excel VBA and doPDF" http://www.dopdf.com/forum/topic/excel-vba-and-dopdf#post-94 Wed, 18 Jun 2008 07:25:59 +0000 Candu 94@http://www.dopdf.com/forum/ I am very impressed with doPDF. I am adept at Excel & VBA macros but can't figure out if/how I can pre-populate the PDF filename in the pop-up box. Is this possible? I am changing the printer to doPDF then running: Sheets(Array("sheet1", "sheet4", "sheet6")).Select ActiveWindow.SelectedSheets.PrintOut copies:=1, Collate:=True This works fine but I'd like to populate the name field.