I made a modification that allows me to create the .pdf using the free software, PDFLite, but now the file won't open with Adobe. What version of the Acrobat reader do you have? Thanks for your feedback, it helps us improve the site. DOCmd.OutputTo will send an Access object to a PDF file. When IE starts it defaults to the default printer.
.xlam add-in. All Rights Reserved. This tutorial will demonstrate how to save / print to a PDF in Excel VBA. But I could be wrong since I haven't got the code to even execute yet. Jan 7, 2010 #1 Hi friends! *This site is protected by reCAPTCHA and the Google There doesn't seem to be a way to force IE to use a specific printer from VBA the way one can from Access or Excel. I would like it to open the document but not print it... my form name is "myformtopdf" Also, the file name should be based on these two other fields within my database...can that be done? that will print the ActiveSheet to a PDF: The function returns TRUE or FALSE if the print to PDF was successful or not. My problem is printing through Excel VBA. I personally don't see how it applies to my question because it looks to me like the code will print the value of the "Msg" variable....not the pdf page. Nobody was able to solve this problem. I have an Access Form with comboboxes that allows a user to select different information. When a command button titled "Print" is clicked, I would like VBA to open a certain Excel workbook based on the combobox inputs, then select the "PDFLite" printer, print a certain spreadsheet based on combobox inputs, and then I can automate the Save location also based on combobox inputs.
This thread is locked. I'm trying to create a macro that will print the active sheet to PDF, and automatically save it using the contents of cell B3. © 2020 Spreadsheet Boot Camp LLC. Sub SimplePrintToPDF() ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:="demo.pdf", Quality:=xlQualityStandard, _ IncludeDocProperties:=False, IgnorePrintAreas:=False, OpenAfterPublish:=True End Sub . Privacy Policy and Also, I posted my work around so that others have another option if they too run into this problem. I need a piece of vba code to print my form to a pdf document? Become a member today and access the collective knowledge of thousands of technology experts. Simply navigate to the menu, click, and the code will be inserted directly into your module. Print to PDF. VBA to print sheet to PDF and save using name in cell.
Thanks for subscribing!
PDFLite may be a later incompatible version. The error occurs on the following line: (Get your first solution completely free - no credit card required). Please check your email. Contact me to learn more. 1 Solution. Please check your entries and try again.