Search:

Type: Posts; User: Eric H; Keyword(s):

Search: Search took 0.00 seconds.

  1. Re: VBA to save as PDF and mail PDF to Specific recipient/s from Specific Account with Specific Signature

    @
  2. Re: VBA to save as PDF and mail PDF to Specific recipient/s from Specific Account with Specific Signature

    No worries Werner,
    Always happy to help out a fellow Excel & VBA enthusiast.
  3. Re: VBA to save as PDF and mail PDF to Specific recipient/s from Specific Account with Specific Signature

    I have downloaded your project and I will look it over asap.
    Please let me if the Excel workbook I created is working for your task. I would be happy to adapt it to better suit your needs.

    Eric
  4. Re: Vba to run macro for multiple excel files within a folder path

    Hi Criscrks,

    I have a few questions if you don't mind.

    01.)Are you saying you would like to cycle through the excel files within a target folder and insert the "=Index,(Match),0)) formula into...
  5. Re: VBA to save as PDF and mail PDF to Specific recipient/s from Specific Account with Specific Signature

    I should have ask this before but I wrote the program to use office 2013.
    What version do you have?

    https://www.dropbox.com/sh/chawlzqtxmv1tbn/AADeYZqHcBjcaN340qcEY55Pa?dl=0
  6. Re: VBA to save as PDF and mail PDF to Specific recipient/s from Specific Account with Specific Signature

    Private Function GetBoiler(ByVal sFile As String) As String
    'Internet reference:
    'https://www.rondebruin.nl/win/s1/outlook/signature.htm
    '**** Kusleika

    Dim fso As Object
    Dim ts As...
  7. Re: VBA to save as PDF and mail PDF to Specific recipient/s from Specific Account with Specific Signature

    Option Explicit

    'Internet References & Inspirations

    'Use the mail account you want in your mail macro
    'https://www.rondebruin.nl/win/s1/outlook/account.htm

    'Insert Outlook Signature in mail...
  8. Re: VBA to save as PDF and mail PDF to Specific recipient/s from Specific Account with Specific Signature

    Hi Werner,

    I am very sorry for the delay in my response I have had several unexpected issues come up.

    After building out the code module to accomplish your task I realized it might be a bit...
  9. Re: VBA to save as PDF and mail PDF to Specific recipient/s from Specific Account with Specific Signature

    Hi Werner Slabbert,

    Could you go into a little more detail of what you would like to do in regards to:
    1.)Creating a PDF.
    a.)Is the PDF to be created in the current workbook?
    b.)Are...
  10. VBA - Create an array from Data within the Power Pivot Data Model sourced from Power Query

    Hello Everyone,
    I would greatly appreciate any help anyone may have on this problem, I have combed the internet looking for an answer but have only slightly gotten close so here we go....

    Is...
  11. Re: File List with HyperLinks to Subdirectories

    I am just a novice but, is this what you are looking for?

    Public Sub Tester_1()

    Dim Obj_Fso As Object
    Dim Obj_Main_Folder As Folder, Str_Main_Folder_Path As String
    Dim Obj_Sub_Folder As...
Results 1 to 11 of 11