print pdf

Hi, Apologies if this is answered elsewhere but I've searched high and low for the answer to this one and even thought I'd found it when I found a Ron De Bruin post on it so tweaked my code to align with his and still no luck. Essentially I have a workbook that runs a list through a template...

I am wondering I have one module with 95%+ of the code for my macro in different subs. what is the cleanest way to do this? Each sub in its own module? also is it better to put all the code that is for just that sheet in a module attached to a sheet? Or other ideas that may help? all my code is...

Hi all, I am quite new with macros in excel, and I was wondering if it is possible to print multiple custom views in one pdf. For example, I have two custom views named as "CV_1" and "CV_2". How can I print both custom views in a single pdf? Also, would it be possible to print multiple...

Hello, I have read the other threads on this topic and had no success. I am trying to batch print groups of PDF files. <colgroup><col></colgroup><tbody> Example area 1: Column K, range K8-K13 S:\Engineering\4-DFdrawings\50168B04.PDF S:\Engineering\4-DFdrawings\50000C004.pdf...

So I have a spreadsheet that has a drop down of 300 schools. Depending on what you select in that drop down, the table below magically updates using vlookups. There is a graph that is linked to that data. https://ibb.co/jaeCKb so the yellow is the drop down E2 The ask of me is to print (PDF)...

Hey everyone, I'm having some trouble getting started with a code for extracting data from different workbooks. I want to be prompted what file i want to take the data from. At my company we save copies of the same workbook into individual clients files. Each file is in the same drive. Each...

As stated, I cannot figure out how to print off PDF files using VBA. I have a code that opens a folder and then is supposed to print off all pdf files in that folder. Can anyone help me out?

How can I print out multiple reports to a predetermined location without it prompting me each time? I have a macro that prints out several reports but I am prompted each time to select where I want the report to go. Can I predetermine where the reports are sent? I tried output file but that did...

Dear all, I found a great macro that prints a PDF and attaches it to e-mail - it work perfectly. However, I need to extend it, in order to first merge 9 different worksheets and then attach them to e-mail in one single PDF file. Here comes the macro: Sub SendPDF() ' Create PDF of active...

Anyone have any suggestions as how to print to a PDF file and every time you print it would append to the file? I have a macro that inputs a code in one cell and the sheet loads new data via a lookup. My macro then prints the table and a series of updated charts. The macro then goes to the next...