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

smtasci

New member
Joined
Jan 24, 2014
Messages
3
Reaction score
0
Points
0
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
 
sendspace.com/filegroup/CkrpnpaGHm0Gy6%2F9etBY3g
 
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
 
Back
Top