Insert vba code in a pdf form and then send the answers by clicking on the send button incorporated in the pdf

[stefanoste78]

Good evening.

I saw on youtube that there is the possibility of creating pdf forms that after being filled in by the user after sending them by email, allow the automatic forwarding of replies via google scheet or drive / dropbox.

Is there anyone who has experience on this?

Then I would like to understand if this possibility occurs through a macro or if it is the excel file containing the macro that is transformed into pdf containing the code gragie to the adob reader professional modules.

Thanks

 

[Jeffrey Mahoney]

Writing to a PDF that allows fields to be input is not really a doable scenario. Even if you could create fields, the end user can't save them to the PDF.

I create forms in Excel on regular sheets. Usually the fields restrict the user to enter what you need or provides a list to choose from. You can create a macro that saves the sheet to a PDF. I created a macro that saved the PDF file and then sent an email with the file attached to the correct email address provided in the workbook. That way the user just had to hit a button.

 

[stefanoste78]

i saw a YouTube video that allows the transmission of data in the PDF form clicking on a button on the PDF.
this is happening in the integration pdf - Google sheet - zapier

 

[Jeffrey Mahoney]

Do share. I'll watch it.

 

[stefanoste78]

Thanks for the reply.
I checked the web and it appears that the author has deleted the video.
I checked here:

https://www.youtube.com/c/ExcelForFreelancers/search?query=zapier

The video looks like these:

With the difference that when those who fill out the pdf form by clicking at the top on send, the data are sent on google scheet without having to send the completed pdf back via email.

If I remember correctly it was a combination of: pdf filler, zapier and google scheet

 

[Jeffrey Mahoney]

You should contact Randy at Excel for Freelancers. He allows you to purchase a whole host of workbooks that he used in all of his videos. The second link below looks like the one you're looking for. Looks like it was reposted to Youtube by a different person. These require at least some knowledge of VBA and a pretty good understanding of Excel.

 

[stefanoste78]

i've already contacted him and he can't find him.
it is similar but it does not do what I want because it is necessary to have the Excel's son open, and it should be a combination of PDF and Google sheet.

 

[Jeffrey Mahoney]

He emails me all the time

 

[stefanoste78]

Does Randy Austin write to you all the time? Why?

 

[Jeffrey Mahoney]

I once purchased a host of workbooks. I'm on his email list for advertisements.