pdf

Hello, I am looking for a Macro that I can use to print a PDF: 3 tabs document, but print 1 time Tab#1, "n" times Tab#2, and 1 time Tab#3, where "n" is a cell in Tab#3. Hope someone can help me with this request. Thanks, AR EDIT: The output should be just one document

Hi there. I am building a database from a PDF source, Each PDF contains around 250 pages that I am amalgamating into one big database, with each PDF page representing one row in the database. The data comes from PDFs, each containing roughly 200 - 500 pages of identically formatted data, so...

I have a spreadsheet with a number of hyperlinks (to files on my network drive) that have been created by concatenating fields. The hyperlinks are active & work as intended in the excel sheet. When I convert to pdf they become flat text. How can I convert to pdf or even a word document with the...

Hi All, I'm trying to get a script that will send a pdf to a specified list of email addresses from within Excel 365. The main kicker is that the Mac version doesn't function the same as a PC version. I've broken this down into 2 pieces. 1) Attached the pdf : If I go to the menu item "Share"...

Hello I use a macro to save mail merged documents into word and PDF files; very handy. I must select all the rows above the row I need in the recipient list for it to work. If I only ticked "Sam" and left "Connor" and "Vincent" unticked, the macro will produce a "runtime error 5631" on...

Hi All, I been given a folder with a list of PDFs and I need to extract certain fields out of it to an excel sheet. However, we are only capable of using Excel 2019, so Power Query was out of the window. I'm currently attempting VBA to solve this problem. However, I'm not well-versed at all...

Hi Guys thanks for letting me join up I am trying to get a VBA to create a PDF of my worksheets (combined sheets, not separate pdf's). The following works perfectly except when BBB (for example) is not in the excel sheet, how do I get the VBA to ignore missing worksheets and still create a...

Hello. I want to be able to print sheets whose names are in a table as a pdf and save it to a predetermined location. I found this but I don't know how to proceed. Transfer Excel Table into a VBA array

I am using JotForms for data collection of names addresses and a short response. I am able to export those responses to a CSV or XLSX. I need to be able to take the responses exported and import it to a Fillable PDF form that was created. I was thinking the only way to do this easily is using an...

Trying to email as a PDF selected ranges with VBA. Hi I tested using ChatGPT to ask the same question and i got the results below. But the data emailed is not using the slicers that are selected. It emails without slicer sections. I want filtered results. Can anyone help. Sub...

Hello again. I have searched this forum and cant find help on my topic. I have a file on a users desktop that will contain a number of pdf files. These files will save to specific folders on Teams ( i have those pathways and have done it with .xlsx and .xlsm files before.) The files have a...

Greetings to all, I am a beginer in VBA, looking for your help to use VBA to generate a daily email about daily production report from PDF file. Email containes a table highlighting production plan vs actual production and remarks column as such : Products Daily Actual production (from...

Howdy! My team receives a bunch of PDF file work orders by way of email, they are saved to a centralized network file location. I currently use a pair of Excel Power Query workbooks to read all of the saved PDF files and put data in their specific columns (in one), create a complete and clean...

Hi there, I have a spreadsheet with input pages and then various tabs for the respective reports. Not all report pages are required, and some are hidden (not visible) based on the users' selections on the setup page. I have a formulated a drop-down list, which shows the reports available for...

I am looking for a solution similar to the following thread VBA to place images inside a PDF??? but instead of adding the image at the bottom of the PDF, is there a way to find a specific text on every page and add the image next to that text? The position of the text to find is different on...

Hi all, Hoping this is a simple fix. I have the below script that I found on another forum that runs as a rule in Outlook to save .pdf email attachments with a timestamp that come from my printer. That part all works fine. The problem I'm having is that it will save the file with the .pdf as...

Hi Folks I want to call various sheets and ranges for printing to PDF depending on certain factors. I've managed to build a code that places the relevant Sheet and Range information into a cell (cell is at "Sheets "Race Meeting Information").Range("DZ1")") and refer to the cell as "DZ1Range"...

Totally confounded by this error. Sub has been working perfectly for some time and today stopped working out of the blue. Error code is 1004 - "Method "ExportAsFixedFormatType" of object _Worksheet failed." The sub takes a worksheet as a parameter then exports it to a pdf in a specific folder...

Hi, I have been given a new task as I'm the most IT literate in the office. I've done a small bit of VERY basic VB coding/Macros. I've stumbled across a code here and wanted to know how I could edit it and implement it to work for my use case. I need to: Export a PDF to the same location...

Hi All, I have this worksheet (see below) that has multiple formatted tables. Users are able to add or remove table rows as needed. What I'm wishing for it to do via VBA is the following: Remove any empty rows from any of the tables Print the whole thing from A2 down to F...the row just after...