pdf

I have a macro to save the workbook into pdf that is currently "running" but deleting a sheet that I do not want deleted. Here are the steps of the macro. 1. Make the necessary tabs visible. - Works 2. Unprotect workbook. - Works 3. Create a copy of a tab for each varation of a value in a drop...

I have created a userform with 3 buttons, "Save as .XLSM", "Save as .PDF" and "Cancel" What I would like is for this command box to pop up when we go to save the document (click on save as > browse) The buttons work just fine every time someone hits Save as .PDF. BUT, it will only work once...

Hello. I have tried and edited a few VBA's without luck on what i need to accomplish. I have a sheet i want to save as a PDF to a pre set folder and then attach it to a new email with certain email address (To, CC1, CC2) I want to file to save as the name/contents of Cell A3 and also set that...

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