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.
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.