Insert VBA code into pdf form

[stefanoste78]

Good morning.

I would like to understand if a pdf can contain vba code because I would like to create one with the code inside to send it to more users via email and receive the answers directly on google sheet.

Thanks

 

[Uncle Gizmo]

Maybe you should be looking at Google forms:- https://www.google.co.uk/forms/about/

 

[Gasman]

Good morning.

I would like to understand if a pdf can contain vba code because I would like to create one with the code inside to send it to more users via email and receive the answers directly on google sheet.

Thanks

Somehow I really doubt it?
Send them a link to your web form on your other thread and get them to enter the data there.

 

[theDBguy]

Hi. PDFs can contain code, but it will be either Acrobat scripting or JavaScript code.

 

[stefanoste78]

Hi. PDFs can contain code, but it will be either Acrobat scripting or JavaScript code.

Have you ever had direct experience?
I would like the answers to be automatically saved on google sheet when the recipient of the questionnaire clicks on submit form.
I seem to have understood that it is also possible with zapier but I have not been able to find it

 

[stefanoste78]

Somehow I really doubt it?
Send them a link to your web form on your other thread and get them to enter the data there.

people no longer trust links so seeing a pdf file may be less wary.

 

[stefanoste78]

I know of the knowledge of google modules but prefer to avoid using links

 

[theDBguy]

Have you ever had direct experience?

Only with integrating PDFs with Access, but not with Google Sheets.

Fillable PDF Forms

 

[Uncle Gizmo]

people no longer trust links

I know of the knowledge of google modules but prefer to avoid using links

But Google Sheets are on the web!

Something's screwy here!

 

[stefanoste78]

But Google Sheets are on the web!

Something's screwy here!

google forms are filled in online. This implies that I will have to send a link that will most likely not be opened since email scams are characterized by the opening of links.
Opening a pdf will be more accepted by those who reconsider the questionnaire.
The answers I would like to be sent on google sheet as happens with the use of google forms.

 

[sxschech]

Have them return the pdf to you and then use vba at your end to parse the data?

 

[stefanoste78]

it's a possibility.
it would be more ideal to be able to send the data directly to Google sheet because people are lazy.

 

[theDBguy]

it's a possibility.
it would be more ideal to be able to send the data directly to Google sheet because people are lazy.

That might still be possible if you can use Google API with some JavaScript code you placed in the PDF form.