Concluído

Add event in google calendar from Excel with VBA

I need a macro which add events in google calendar from Excel.

First, the macro has to clear automatically google calendar when Excel file is open, then add events to google calendar each month from 12 months until 1 month before a date.

For each time « En stock » is written in (B11) to (AMM11)

Event caracteristics :

Calendar name : « Roberto »

Subject : « Echéance de» (B12) to (AMM12) « dans » 12 Months to 1 month before (B24) to (AMM24)

Start Date : 12 Months before (B24) to (AMM24)

Start Time : 7 :00 AM

End Date : 12 Months before (B24) to (AMM24)

End Time : 17 :00 PM

Description : (B2) to (AMM2) (B3) to (AMM3) (B4) to (AMM4) ((B5) to (AMM5)

Notification by email : For each event (At the event date)

So for example in Excel file just below, in (B11) there is « Revendu » so no action.

In (C11), there is « En stock » so the macro has to add 12 events to google calendar based on (C24).

Therefore, 12 events will be written, from 12 months before 24/05/2019 to 1 month before 24/05/2019 and for each events written i have to receive a notification by mail (from google calendar).

The first event is :

Subject : « Echéance de » (C12) « dans » 12 month before (C24)

Start Date : 12 Months before (C24)

Start Time : 7 :00 AM

End Date : 12 Months before (C24)

End Time : 17 :00 PM

Description : (C2) (C3) (C4) (C5)

I have to receive a notification mail 12 Months before (C24)

Next even will be :

Subject : « Echéance de » (C12) « dans » 11 month before (C24)

Start Date : 11 Months before (C24)

Start Time : 7 :00 AM

End Date : 12 Months before (C24)

End Time : 17 :00 PM

Description : (C2) (C3) (C4) (C5)

I have to receive a notification mail 11 Months before (C24)

Et cetera until

Subject : « Echéance de » (C12) « dans » 1 month before (C24)

Start Date : 1 Month before (C24)

Start Time : 7 :00 AM

End Date : 12 Months before (C24)

End Time : 17 :00 PM

Description : (C2) (C3) (C4) (C5)

I have to receive a notification mail 11 Months before (C24)

The next event will be :

Subject : « Echéance de » (D12) « dans » 12 month before (D24)

Start Date : 12 Months before (D24)

Start Time : 7 :00 AM

End Date : 12 Months before (D24)

End Time : 17 :00 PM

Description : (D2) (D3) (D4) (D5)

I have to receive a notification mail 12 Months before (D24)

Et cetera.

If it would be possible to modify colour in the macro it would be perfect.

Sorry for my very bad english ^^

Habilidades: Excel, Microsoft Office, Visual Basic para Apps

Veja mais: excel vba calendar control, create google calendar event using excel vba, excel vba google calendar, excel vba update google calendar, excel vba google data api google calendar, excel vba create event google calendar, api google calendar excel vba, google calendar excel vba, excel vba calendar picker, excel vba format phone numer add, program excel vba price google finance, php event calendar google, install add ins excel vba, php ajax event calendar google calendar, excel vba add installation

Acerca do Empregador:
( 1 comentário ) Le Mans, France

ID do Projeto: #14537475

Concedido a:

abhinovpankaj

Hello, I have already done similar project ,I have the VBA file with me,which will work with just few tweakings as per your requirements. I have been working as freelancer since last ~ 5 years,prior to this was worki Mais

€44 EUR em 1 dia
(31 Comentários)
5.1

8 freelancers estão ofertando em média €44 para esse trabalho

schoudhary1553

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of ex Mais

€100 EUR em 1 dia
(168 Comentários)
6.8
€23 EUR em 1 dia
(16 Comentários)
4.2
Rohansohan111

A proposal has not yet been provided

€12 EUR em 1 dia
(4 Comentários)
1.8
leoponegraphics

- 15 days error free service - Continued support after the delivery of final product - Clear communication throughout the project Relevant Skills and Experience https://www.freelancer.in/u/leoponegraphics.html Prop Mais

€100 EUR in 0 dias
(1 Comentário)
1.6
€23 EUR em 1 dia
(0 Comentários)
0.0
madhuramohan2003

A proposal has not yet been provided

€23 EUR em 1 dia
(0 Comentários)
0.0
Ruhithasan94

I can do anything in Excel and follow what you need. I also can do like: -- Any type of Data Entry -- Copy-Paste Job -- Web-Research -- Searching Job Thank you for viewing my profile!

€23 EUR em 1 dia
(0 Comentários)
0.0