Devam Ediyor

Excel-VBA to fetch Google Forms-data

Prehistory:

We have a Microsoft Excel Workbook with graphs and a lot of complex calculations. The graphs and results of the calculations will be based on choices a user has done on a Google-form. When we have a new user of the google form he/she will give their e-mail. This will work as an ID when fetching the data.

The data will be put into the "input"-cells of the Excel-sheet and the calculations and graphs will create the result.

In the end we want to be able to send a PDF with the results back to the user.

Excel-vba 1:The program should fetch data from a Google Forms and put it in Excel. The data to be fetched is filtered by an 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.

Excel-vba 2: 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.

Beceriler: Excel, Yazılım Mimarisi, Visual Basic, Uygulamalar için Visual Basic

Daha fazlasını gör: excel vba access sheet data, updating excel vba workbooks without changing data, excel vba return xml data type, vba download google spreadsheet, sync google spreadsheet with excel, how can i link google sheets to excel in real time, can excel read google sheets, automatically convert excel to google sheets, excel vba get data from google spreadsheet, link google form to excel, import data from google sheet to excel vba, excel vba look data sheet, vba excel pop gui user input data, program excel vba price google finance, excel vba chart click show data, excel vba example read cvs data, excel vba create chart display data, excel vba download yahoo financial data, excel vba macro copy columns data, edit google forms data

İşveren Hakkında:
( 71 değerlendirme ) OSLO, Norway

Proje NO: #19176329

Seçilen:

aubrey03

I am an Excel and VBA specialist with a lot of experience in creating complex automation tools, formulas, databases, queries and macros. You may check some of my projects here: [login to view URL] Daha Fazla

%selectedBids___i_period_sub_7% gün içinde 100%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(87 Değerlendirme)
5.5

Bu iş için 16 freelancer ortalamada $130 teklif veriyor

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. Daha Fazla

$200 USD in 3 gün içinde
(327 Değerlendirme)
7.8
polarjin2017

I have seen the project - Excel-VBA to fetch Google Forms-data. I have been working in these fields((Excel, Software Architecture, Visual Basic, Visual Basic for Apps)) for 7 yrs as a freelancer. I will never disapp Daha Fazla

$150 USD in 3 gün içinde
(120 Değerlendirme)
6.9
lightingdavid

Hello. I have good skills in "Excel, Software Architecture, Visual Basic, Visual Basic for Apps". I have working for 7+ years in this field. I 'm very interest to your project. I have checked your project descripti Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(72 Değerlendirme)
5.8
vsprybhanu

Hi, My name is Virendra. An Experienced Data Analyst and Macro Developer. I have read your instructions carefully. I can develop both macros which you described. Macro can extract data from google form, ma Daha Fazla

$250 USD in 3 gün içinde
(72 Değerlendirme)
5.4
bhupendrayadav

I have more than 5 years of experience in advanced excel, VBA automation and data processing. I have successfully completed similar projects, please have a look at my portfolio for details. I can integrate google forms Daha Fazla

$80 USD in 2 gün içinde
(19 Değerlendirme)
4.1
ajittomar9

Dear Client, Greetings. I would absolutely love the opportunity to build the Excel VBA scripts to fetch Google forms data for you. I am an experienced Excel and Google sheets programming Expert seller on Freelancer. Daha Fazla

$180 USD in 3 gün içinde
(3 Değerlendirme)
3.8
coolmob0816

Dear Client. I respect you and will follow all your requirements. I am so happy to see your kind requirements I'm a senior VBA developer and I have enough experiences in Excelspreadsheet/Googlespreadsheet. Of cours Daha Fazla

$100 USD in 3 gün içinde
(4 Değerlendirme)
3.7
arash18k

Hi, I can write the cod for you in Excel (VBA) or in the google sheet (by google script), in the case you want to not have your data in Excel and do all the work in google sheet (both can be done). You can see my prev Daha Fazla

$100 USD in 3 gün içinde
(5 Değerlendirme)
3.4
bluesea1990

I have many experiences in Excel VBA developing. Of course I know all of Excel and VBA programming. Your task is suitable with me. I'm software engineer with C, C++, C#, SQL, PHP .... Regard your good .

$155 USD in 3 gün içinde
(6 Değerlendirme)
3.2
malviya786

hi there I have extremely good knowledge of excel vba. I have read your requirement of both VBA program, and I am very confident that I can complete them in one day as per your requirement. waiting for your response

$55 USD in 3 gün içinde
(1 Yorum)
0.4
sackeywill

Although I'm new here excel related works are the work I greatly enjoy doing well all the time. I have gained 6 years experience whilst working with the Noguchi Memorial Institute for Medical Research as a Senior Resea Daha Fazla

$40 USD in 3 gün içinde
(0 Değerlendirme)
0.0
techlinesols6

"Hi, Hope you are doing well! Thanks for sharing your project requirement with us. It will be our great pleasure to work on your project. I have checked your requirement, yes we can do it, because we already work on si Daha Fazla

$208 USD in 7 gün içinde
(2 Değerlendirme)
0.0
kakkarak1960

Hi, As per reading your description and your requirements, I am offering you that I can provide excel management in accordance with all the requirements which you need. The creation and management part comes with a Daha Fazla

$100 USD in 3 gün içinde
(1 Yorum)
0.0
nurulainmarzuki3

hello, i am very interested with the job. i have no experience in data entry but i am excellent in using Microsoft Excel, Word and Power point. Moreover, i'm fast learner and open to learn new experience, hard working Daha Fazla

$166 USD in 4 gün içinde
(0 Değerlendirme)
0.0
mohdfairosmfmy

Dear Sir, I interested to work with you on your project. My Experience and service skills made me an ideal candidates for this position. I will do the job quickly, accurately and according to your time frame/schedu Daha Fazla

$100 USD in 5 gün içinde
(2 Değerlendirme)
0.0