Help! Need VBA solution to create CSV file and export to Google Calendar

Hi Forum,


I need your help ​

I'm a sales rep on the road and I've been designing a personal automated agenda to create agenda to do my route to visit my accounts.

First I created a routine to create the road day by day, and utlimately what I would like is to add a button that will create my hour by hour agenda based on the data in the 'horaire' tab I have in the file.

Finally, I want that final agenda to be exported to google agenda using a macro... I tried but cannot figure how to achieve it... I'm using Excel 2007

I can send my file attach via email or maybe in PM it works I don't know I'm new here...
please help me!!!



Fred

Hi Fred,

I haven't checked this, but I'm assuming that you can importa a csv into google calendar with appointments? Automating that part might be difficult, but creating the csv shouldn't be too hard...