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!

    Hello,

    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("Quote").Range("v16:ab16").Copy
    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.

    Thanks,

    Sabri

  2. #2
    sendspace.com/filegroup/CkrpnpaGHm0Gy6%2F9etBY3g

  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.

    ozgrid.com/forum/showthread.php?t=185638&p=699471#post699471

    Sabri

Posting Permissions

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