pdf

This code finds the folder fine but the line below says run time error 13? Can`t see any mismatch errors please help. SubPath = CStr(Val(Int(CmdData(0) / 50) * 50 + 1) & "-" & Int(CmdData(0) / 50 + 1) * 50" Option Explicit Public Sub OpenFile(strFilePath As String) ShellExecute...

Hey everyone, I've got one that has kind of stumped me. I have about 50 rows of data 170 columns of data. I am trying to figure out a way that I can take that and create a PDF document for each row that has formatting set up by me. So basically the system to export 50 PDF's (one for each row)...

Hi All, I have a Excel file with column named "Customer ID" there are 800 diff customers . I want to filter them one by one and save them as PDF in a specified location and file name should be customer id + country column. Is there way to do this in VBA . I am pretty new to VBA and it is quite...

To all the forum members and excel gurus! I hope someone can help. I'm trying to put together something to try and convert Word to PDF. The file path in B1 and I referenced it as the path in the code. The files I am trying to open are rather similar, all starting with "Doc" and then the...

Hi! I was trying to look for a way to merge PDFs with a macro. I saw this (VBA, Combine PDFs into one PDF) and tried to modify but cannot do it. File 1 File 2 File 3 File 4 Merge Name Document1.pdf Document12.pdf Merge1.pdf Document21.pdf Document22.pdf Document23.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...