pdf doc vba

  1. A

    VBA command to open PDF

    Hi All, my first post here :) I am trying to create an interface to select and open PDF reports from Excel. Currently I have got 4 drop down boxes where users can select which report they would like to see. Currently the options are drop down box 1 : Europe, America and Pacific drop down...
  2. WERNER SLABBERT

    VBA to save as PDF and mail PDF to Specific recipient/s from Specific Account with Specific Signature

    Hi there .... i recently found this thread "https://www.mrexcel.com/forum/general-excel-discussion-other-questions/710212-vba-code-convert-excel-pdf-email-attachment.html" that does more or less what i want in my VBA but implementing it into my Current VBA is no easy feat, would anyone be so...
  3. B

    Moved PDFs from one location to another

    Hi. Not a pro coder but this is what I have so far. Sub SaveasPDF() Dim wsA As Worksheet Dim wbA As Workbook Dim strName As String Dim strPath As String Dim strFile As String Dim strPathFile As String Dim myFile As Variant On Error GoTo errHandler Set wbA = ActiveWorkbook Set wsA =...
  4. G

    Import PDF in Excel and send to attach the same excel

    Hi I need import and need to select the pdf file and send the same file to mail via Excel VBA forms. Can insert selected cell that imported file?
  5. A

    Error handling help

    Hello, The following code creates a PDF document based off named ranges on cells. However it fails if the PDF document is already open. Can someone please add error handling to this, so it will not bug out. Code below is what VBA highlights and there is a yellow error next to this line...
  6. N

    VBA Code converting .doc to .pdf skips first document

    Hello, I have the following code to convert Word documents saved in a specific folder to PDFs, but when the code is ran, it skips over the first file in the folder and doesn't convert it. If i run the code a SECOND time, it will convert it. Any ideas why it skips over? Sub DOC_PDF()...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top