pdf

Hi guys, I want ask from you about one thing which came into my mind and take some recommendations about it. I have a lot of PDF drawings which I should check and count the type and total Amount of Joints. The whole process which I want to automate I will write below Step By step: All job...

Hello MrExcel, I have a macro that essentially exports text in 3 columns into a word document before converting to a PDF. I have had to do this as the text in 1 of the columns is well over 300 characters and can't be done in excel. Unfortunately when i run the macro it takes about 13 minutes...

Hello everyone! I have found a lot of help reading these forums (Google search results) and learned quite a bit. I am no expert and have an issue. I have a workbook with several sheets that combine results into one final sheet - a purchase order. Since this sheet is dynamic and can include...

Hi all, I currently have this VBA code: Option Explicit Private Const FilePath As String = "S:\COMPANY\FOLDER OF COMPANY\FOLDER 15\TEST FOLDER\Attachments\" Sub send_email_complete() Dim OutApp As Object Dim OutMail As Object Dim i As Long Dim ws As Worksheet Dim col As...

I have the following scenario: I have up to 200 different folders on my desktop. In each of these folders, I have up to 15 different pdf files. So I might have the following: Folder A: Maths.pdf , English.pdf , Science.pdf , Geography.pdf Folder B: Maths.pdf , English.pdf , Geography.pdf...

Hi, I'm basically looking for a method to merged all filtered .pdfs based on "work pack" column into one pdf using the button shown, see image attached. Is this even possible? I've seen methods using Acrobat Pro which I do not own. If when I click the button, it generates a merged pdf file...

Dear all, (Please note that I am using the Outlook program in Windows). I currently have a setup that looks approximately like this (please ignore the snippet on the right side, it is purely to show what an email looks like in an outlook format): I was wondering if it would be possible to...

Hi all, I have this VBA code to write an email body text: eBody = "Dear person," & "<BR><BR>" eBody = eBody & " 1Text text Text text Text text Text text Text text Text text Text text Text text Text text Text text Text text Text text Text text Text text Text text Text text Text text (Text text...

Hello, I currently have thousands of folders with each of them having up to 10 .jpg image in them. My goal is to create a macro that goes over all folders, and for each of them, converts all .jpg files inside it into one PDF (1 img/page). I have successfully made the macro for one folder, so...

I have a list of items in a spreadsheet which are maintained by a designated person to ensure they are current and applicable. I have created a pdf form which is pretty much empty apart from simple things like an email address, logo. I want a different designated person to open that form and...

I am running a macro that executes numerous operations on a file, and I want it to automatically save and export to PDF at the end. It must use the Acrobat add-in, not Excel's built-in PDF conversion, because each sheet needs to be bookmarked in the output (and that's not possible with the...

I want to convert ranges of rows in excel to pdf file with vba.but with specific format in a different sheet. Which I have done so far. But the problem is , some how my code is ignoring the rows with similar values. I want to add all the rows with similar values under the pdf file. for example...

Hey, I have a problem with exporting a range of data to an PDF file. I looked around this website but none seems to give me the solution. I am using this code to export a PDF file, which than will be attached to an email, this works perfect. ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF...

Hi All Really hope that someone can help with this. I've spent most of the day trying... and failing. I have a few hundred PDF documents in a Shareholder folder and I'm looking to open them via an Excel hyperlink. The code below works when the files are saved on my local drive, but fails...

I am designing an excel tool that sends end of month Account Summary to colleagues emails while attaching the summary as pdf. The list of staff is already in a worksheet named "Staff Record" starting from cell S2. The staff emails is listed in column U starting from cell U2. The transaction...

This code works but I just need Pdf file how can I alter it so it just collect certain files Private Sub Fill_DrNumbers_Click() Dim FSOLibary As FileSystemObject, FSOFolder As Object, FSOFile As Object Dim FolderName As String Dim SourcePath As String Dim...

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