Program Google-script and Excel VBA

Closed Posted 5 years ago Paid on delivery
Closed Paid on delivery

The result of this project is 3 texts. The texts are:

1. Google-script: We have registered a Google Form. If someone fill in this form we want an e-mail sent to us with the e-mail-address they entered in one of the google-fields. You do not need my Google-form. Create your own with a text-field for the e-mail and a button and make sure the script sends that e-mail to a fixed e-mail-address.

2. Excel-VBA: Again - I only want the code - I will install it and tweak it myself. The program should fetch the Google Forms data and put it in Excel. The data to be fetched is filtered by the e-mail the user of the Google-form has given. In your code you can just create a test-sub where you manually set the e-mail-address just to show it works. I will tweak it to work with my sheet and pick the e-mail from where I want.

3. Excel-VBA: 2 sheets in the workbook should be sent as PDF on e-mail to that E-mail address. We will format the sheets with content from the google-forms and respond by sending the e-mail back to the Google-forms-user.

Summary:All in all we have Google Forms (but you do not need mine) and we have an Excel-sheet (but you do not need mine). What we need is to get an e-mail when someone fill inn the form and from Excel to be able to fetch that data and send the result as PDF to the e-mail-address.

JavaScript Visual Basic

Project ID: #19006666

About the project

7 proposals Remote project Active 4 years ago

7 freelancers are bidding on average $145 for this job

schoudhary1553

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. More

$250 USD in 3 days
(321 Reviews)
8.2
nvchien94

Hello there, I am an Excel VBA coder and also have skills at Google Sheets App. I can create this macro for you. I think it's can be complete in 1-2 days. If you want example. Please contact , I can draw a fast scri More

$200 USD in 1 day
(155 Reviews)
6.2
dvcontact

Hi, Reading your project description about writing program that will send email address to you from the information filled in Google form by users and transfer data from the Google form to Excel Workbook and send the More

$150 USD in 3 days
(14 Reviews)
6.0
romanapanovich

Hi I can do it in Google Sheets - and i have some thoughts why it is right way instead of excel a) Excel doesnt have good Event-based system. VBA is already old system and isnt good for internet processes b) Google More

$120 USD in 3 days
(12 Reviews)
4.9
stanleyw12

Hi Sir/Mdm Thanks for reviewing my application. I am well versed in VBA having used it in various financial institutions. As I am a new freelancer, I am willing to do this job at a cheap cost or even for free. Pleas More

$30 USD in 1 day
(7 Reviews)
1.9