pdf

Hi, Looking to use a Macro in excel that saves document as PDF but the file name needs to be: Cashing Up Week End (Cell N4) which is a date Hope someone can help! Thanks

I have a macro that prints several pdf's for schedules from one sheet. It takes about 10 minutes for the macro to run and make the 10 pdf's. Is there a way to make this run faster? Sub Create_Schedules() Sheet1.Activate ActiveWindow.View = xlPageBreakPreview Dim Yellow As String Yellow =...

Dear Members, I am using the following code to display photo from a folder in my excel sheet. Sub DisplayMainPicture() With Sheet1 On Error Resume Next .Shapes("ReceiptPic").Delete On Error GoTo 0 If .Range("I12").Value = Empty Then Exit Sub PicPath = .Range("I12").Value 'Picture Path If...

I have a successful route of pulling information from a collection of PDF files (with structured tables) that are located on a Network Drive. I am now running into an issue where the Power Query refresh stops when it finds a PDF file with a full Path/File Name that exceeds the Microsoft Office...

Hello, I'm pretty new in Excel VBA so I don't know much about it. Basically I want to create a tool which can take PDF files from the folder in which the excel sheet is saved and paste them in Excel rows, Like if there are 4 PDF Files in my folder then I want the tool paste all of them in...

Hi all, I have this overview at the moment: If I manually choose to save my file as a PDF, it works fine and I get just 1 page with the overview above. However, I have the following VBA code to save my file as a PDF: Option Explicit Sub SaveFileWithMacro() Dim Path As String Dim fn As...

I have tried to search and can't find anyone reporting a similar question/problem. I have a macro that filters some data, and then creates a PDF file from the filtered data, so far no problem. Then I have a macro that then sends the PDF file as an attachment in an email, but the problem is...

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