1. M

    Email PDF code - save a copy

    Using this code from ZVI's examples on another thread - it kills the PDF at the end, how can I make it save a copy in a location, with the file name from cell C4? Sub AttachActiveSheetPDF() Dim IsCreated As Boolean Dim i As Long Dim PdfFile As String, Title As String Dim OutlApp As...
  2. M

    VBA Code - Data Not being Added to Empty Row

    Hello, I am having an issue with my code below (this is not the full code). I want to add data into the empty row after the last row used. In my AuditData tab row 1 is the header and everything else is blank. So the data should be added into rows 2, 3 and so on. The code works, but not as...
  3. S

    VBA PDF Export printing 1 page

    I have used this VBA code for publishing a PDF report which does work, but what it is doing is showing 2 blank pages below the PDF report been published. Is there anyway to say to the report to export just the range I want leaving just 1 page instead of throwing out good paper!. Private Sub...
  4. G

    VBA to convert tabs to PDF if selected from cells

    Need to macro to convert selected tabs to PDF Say in A1 to A10 is the tab name and the in B1 to B10 is true or false If it is true in B1 to b10 then it will convert them to PDF
  5. A

    Save Excel worksheet as PDF

    Hi Exports, I am trying to save excel worksheet to PDF however encountering runtime error 1004 with the msg with reads as "Document not saved. The document may be open, or an error may have been encountered while saving. when clicked on deburg, below in bold is highlited in yellow. Kindly...
  6. A

    VBA print to PDF issue on windows 10

    Hi, I'm quite new with VBA coding and need to solicit help from you. I have an existing coding regarding the print to pdf using adobe acrobat. My laptop was upgraded to windows 10 and the adobe acrobat was removed and changed to microsoft print to pdf. Now my coding didn't work eventhough...
  7. F

    VBA Fill in multiple PDF Files

    I have a code to fill in multiple PDF files from data in an excel sheet. It gets data from the first row and fills in the pdf and saves it. Then I need it to go to each line and fill in a new pdf and save it. When it creates the first pdf and saves it, a preview of the pdf comes up. Then the...
  8. L

    Power Query Does Not Import Multiple PDF Pages

    Hi, I'm using Power Query for Power BI Desktop and when I connect to a single PDF file the last record only shows the data for the first page and not the rest of the pages. The rest of the data is the same as the first page. Can Power Query read multiple pages for one PDF? If so, how can I...
  9. M

    VBA Error: Object variable or With block variable not set - while looping through directory

    Hello, Hopefully I will not confuse anyone. I am getting an error for my code below. I copied the entire code in case anyone also has ideas to optimize it as well. The purpose of the code is to: Look though all PDF files in specified directory When it finds the first PDF file Open the PDF...
  10. V

    Print specific sheets seperately to printer and PDF

    Is this doable and could someone suggest a script? (Script would need to be seperate) 1. Print sheets seperately without prompt to the default printer: only if the sheet contains the text: "PrixMax" "6po" "Quote" (Then print them, else ignore) 2. Create a PDF per sheet (If sheet contains the...
  11. countryfan_nt

    Run-time error '-214702894(80070002)' - Cannot Find This File.

    Hello friends, hope all is well! Please help me with the code. it supposed to take the sheet PDF, convert it to a pdf file and send it via outlook. I am getting the run time error. The Debug is highlighting the line: .Attachments.Add PdfFile Thank you so much in advance! Private Sub...
  12. G

    Help to create vba for "save as" and create PDF

    Hi, I don't know anything about vba so i need some help here. I got this code: Private Sub GemSom_Click() MkDir "C:\Users\Martin\\\\\\\TEST" & Range("b6").Value & " " & Date Dim Path As String Dim FileName As String FileName = Range("b6").Value & " " & Date ActiveWorkbook.SaveAs...
  13. T

    Exporting Each Tab into PDF

    Hello, I have the VBA code below. End goal is to have each tab in the workbook to be exported into its own PDF. Problem: it works fine on my computer, but when someone else tries to use the macro on their own computer, it errors. Sub ExportToPDFs() ' Save Each Worksheet to a separate PDF file...
  14. B

    Macro for opening a pdf

    Is it possible to have a macro in my personal workbook that will open a pdf named job list thats in a certain folder.
  15. B

    Need VBA to interact with PDFMaker addin

    Hi all, I have an Excel file with internal links that needs to be saved as PDF. I have found a way to manually do this using the PDFMaker add-in, but am now trying to automate this but am really struggling. I've tried to Google some results but have had no luck there either. Does anyone have...
  16. K

    Web Scrapping - Download PDF after submitting Policy

    I want to download the PDF file after pressing "Continue" with below code... ================================Code========================= Sub automaticformfilling() Dim ie As Object Set ie = CreateObject("internetexplorer.application") '1 GoTo website With ie .Visible =...
  17. D

    Help - vba convert slicer to pdf file?

    Hi, I have a horse racing spreadsheet and want to convert each slicer data into a pdf file. for example i want to print the race meeting (slicer 1) and each race number (slicer 2) at that meeting into a pdf. is this possible using vba?. basically i want the pdf file to read like this race...
  18. M

    Loop through Folder for PDF Files - Open PDF in Word and extract text into Excel

    Hello, I am using the code below in Excel to open a PDF File in Word andextract the data as text only into Excel. The code works perfectly fine as itis, however, I want to loop through all pdf files within the folder instead ofhardcoding the filename in pathAndFileName variable. My goal is...
  19. I

    MsgBox yes / no advice

    Morning, I have the code below but would like some advise for a slight alteration please as i got lost with the yes / no part of it.. The code saves a screen shot in the form of a PDF file. The Yes / No box is where im stuck. Clicking No would just continue to save as normal Clicking Yes...
  20. P

    Save same sheet to PDF multiple times - is it possible?

    Hello, I'm a new poster to the forum. I have a question and cannot find the answer anywhere so I thought I would ask here. I would like to know if it is possible to save the same sheet to a PDF in a loop (with different data each time) creating a multi-page PDF. As a test, I have been able to...

Some videos you may like

This Week's Hot Topics