We could show you how to switch printers. I though so that Excel can't control Adope's printing menu. I have made the changes in Adope and all works perfect now. Thanks for your time and your help.
Hi all I'm using Excel and have Adobe Reader On Error GoTo 0. SaveOnly: MsgBox "A copy of this sheet has been successfully saved as a. I have an Access Form with comboboxes that allows a user to select different information. I have a free software called PDFLite and installs on my computer as a printer. Worksheets "Rental". Range "A1:N24". ExportAsFixedFormat … Reviews: 5. Click here to reveal answer. Joined Jun 17, Messages 2, Click to expand You must log in or register to reply here.
Similar threads C. Solved Error Message. CarlStephens Nov 24, Excel Questions. Replies 4 Views Nov 24, dmt CarlStephens Oct 28, Excel Questions 2 3. I'm looking to expand my automating to include directly printing to PDF. The macro s I have written already formats the print area and page setup as I need it. But when I go to record my macros nothing for printing, changing printers or saving to file is captured. Is there a way to accomplish this? I could even get by if it just required a save location prompt.
The file name I would imagine could be auto-generated by grabbing existing info within the spreadsheet. Use the following code in your macro to save your file as PDF. Edit: If you intend to publish the entire workbook as PDF and not just the sheet you are working on just replace Active Sheet.
Sign up to join this community. The best answers are voted up and rise to the top.
0コメント