pdf

Hoping someone can help me. I have most of the coding worked out but i cannot get it to agree to save with the custom file name. I have two different pages which display data slightly differently depending on the user need. The result should be that they pick which report they want to generate...

Hi everyone! I'm trying to compare some serial numbers and delete the duplicates. The thing is that I need to compare between an Excel file with a list of the serial numbers, and PDF files, each with its own serial number. So I need to check which of the serial numbers in the PDFs are already...

Good evening the ever amazing MrExcel community :), I have another problem I am trying to overcome....I have a workbook with 95 worksheets of which I need to save 84 on a monthly basis as a pdf and distribute to the business. Current WoW is just to select the tabs and save manually but looking...

Hello, I am converting PDF with Power Query and run into the problem. The conversion separates text into two rows for the column "details" and keeps the rest columns blank. The issue is not regular; sometimes it appears after every row, other times after couple of rows. How may combine this...

Good morning incredible excel people! ? I hope you’re all going well this sunny weekend. I was just wondering if someone might be able to help point me in the right direction or if you have any ideas that would be greatly appreciated. I have the below module that takes two sheets and inserts...

Good morning All. First time poster, but have used the forum and associated code more time then I care to admit! Unfortunately, I have not been able to find/modify code to achieve what I want to do. I have workbook that has a number of sheets (for this example, they are named Item1 to Item8). I...

I have made VBA code to print PDF any excel sheet. But i am running this code, i am getting one extra page that is blank, can you please help to rectify this problem. Sub Macro1() ' Dim lRow As Long Dim lCol As Long Dim sht As Worksheet Dim StartCell As Range ' Sheets("Sheet1").Select...

I found something for excel but nothing for word. can someone please help if there is such a program? Thanks in advance.

I have a CSV file sent to myself weekly which has 100 rows in it. I need to convert each row into a single PDF which is formatted with company logo and looks pretty. So I have set up a template excel file with a sheet called 'rawdata' where I paste the CSV into. (Roughly 50columns, 100 rows)...

Hi, Looking for some help creating a VBA code or IF function that will open a .pdf based on values within 2 different cells. For instance Column F can have a range of Chapter numbers e.g 32, 52, 55 etc. which relate to specific folder names saved on a drive (for this example: my desktop) I.E...

I have to start by admitting that it's been a long time since I even attempted VBA and despite a few hours of trying different methods/blocks this week, I am still not getting the result I want, so I'm hoping someone can lend a hand. I have a workbook shared by my team and I need them to be...

Good morning I have an issue with a piece of code where I'm unable to fit the pdf export to one page - the end column always spills onto a second PDF page. The code attached is part of a larger project, which all works fine, apart from this one export. I don't have much experience with page...

The following code I created is to save the Excel sheet PDF file in a specific folder with a specific filename according to the value of the variables Dim FilePath As String Select Case MachineName Case "A4", "A8.1", "A8.2", "A8.3", "A12.1", "A12.2", "A12.3", "A20.1", "A20.2"...

Hello, first time posting here. I have found plenty of helpful code and would like your help. Every month I get a list of statements and invoices that I would like to make a code that combines these pdfs and save them under the statement file. For example: Teststatement.pdf test1 testpart2...

Hey guys, Is it possible to use VBA to place images inside an existing PDF with accuracy and precision? Even better, could VBA be used to place said images into an INDD file? If not, is there a different scripting language that is suited for such a task? I’ve been creating print-advertising...

Hello! I am new to this forum and somewhat new to Excel/Access VBA. Have been able to find solutions to most my problems in this forum already except for this one. I have an excel workbook used for doing quotes. It's more like a form than anything. I want to use Access to store the quote...

Hello, I'm looking to loop through all the pdf's in my folder. I need to copy all data in the pdfs and paste it into my workbook(sheet1) where i will call other macros to process the data. Once the data has been processed i will clear Sheet 1 with another macro before returning to this original...

Hi all, I would like to make a button on each sheet of a workbook which will save the sheet (excluding the button) as a PDF to the desktop. Each sheets starts off as a blank sheet, the blank sheet is copied and data entered, sheet renamed as needed. The data on each sheet will be reviewed...

I have a pivot table taking up a single column on a worksheet. The table contains a name and a date in the row field of the pivot table. The purpose is to summarise dates allocated to a person. When I print the table to a PDF it puts on column on each page. Is there way to spill it into 3...

Hi all I am in the process of creating performance reports. I am looking to save multiple PDF documents from one sheet however I need one cell to change before each saves to PDF. Excel Document Overview Sheet 1 = Report Template (A1:K34) Sheet 2 = List of Employee's names (B2:B151) Sheet 3 =...