Program Google-script and Excel VBA

終了済み 投稿 5年前 着払い

$30-250 USD

着払い

終了済み 着払い

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 ビジュアルベーシック

プロジェクトID: #19006666

プロジェクトについて

7個の提案 リモートプロジェクト アクティブ 5年前

お金を稼ぎたいと思っていますか？

Freelancerで入札する利点

予算と期限を設定してください
仕事の報酬を受け取りましょう
提案のアウトラインを作成してください
登録して仕事に入札するのは無料です

7人のフリーランサーが、平均$145 で、この仕事に入札しています。

schoudhary1553のプロフィール写真
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. もっと

$250 USD 3日以内
(321件のレビュー)
8.2
nvchien94のプロフィール写真
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 もっと

$200 USD 1日以内
(155件のレビュー)
6.2
dvcontactのプロフィール写真
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 もっと

$150 USD 3日以内
(14件のレビュー)
6.0
romanapanovichのプロフィール写真
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 もっと

$120 USD 3日以内
(12件のレビュー)
4.9
stanleyw12のプロフィール写真
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 もっと

$30 USD 1日以内
(7件のレビュー)
1.9
このようなプロジェクトを投稿する