New to Macros - I would like to understand how to save a file with vixed values in the name as well as values from cells

  • I have the below code created as I want to save contractor invoices that come to me as excle and save them as PDF.

    I would like to have the value 111 below be the value of cell F5 and the value D94786 be the value of cell B19.


    I have googled many things but kind find the exact code I need to make the change to the current Macro I have.


    Thank you.


    Mark


  • Mark, welcome to Ozgrid.


    Please take a few minutes to read the Forum Rules, there's a link in my signature below. I have added code tags for you, the rules will explain why.


    Try this,