Results 1 to 3 of 3

Thread: Auto-export worksheet to fillable PDF form using a macro button?

  1. #1

    Auto-export worksheet to fillable PDF form using a macro button?

    Register for a FREE account, and/
    or Log in to avoid these ads!


    I've created a worksheet that allows my team to build an order for a customer. I've created a PDF form with blanks so they can fill in the necessary values in the correct fields ie. Tariff Name, Handset Name, Minutes etc.

    I'm hoping to create a macro button that will export all the the data needed and auto fill the PDF form to save time.

    So far I've added a button with the following code

    Sub CopyData()

    Sheets("Sheet1").Cells(Rows.Count, "A").End(xlUp).Offset(1, 0).PasteSpecial Paste:=xlPasteValues

    End Sub

    This simply adds all the data needed onto a separate sheet ready to be exported as a csv.

    I'm in need of the rest of the code to export/import Sheet1 into my fillable form.

    So far attempts to export to .csv have turned my entire worksheet into a .csv file or caused errors within the code.

    I've attached a sample of my Workbook and PDF form below.

    Excuse the messy worksheet. I'm going to tidy it up once I've cracked this.



  2. #2

  3. #3
    In case it's useful to anyone else, I've managed to solve my issue.

    Details and example files can be found on a thread I created on another forum.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts