Outlook Calender to Excel Spreadsheet

J

Jason

I have a spreadsheet that will track my time at certain places. I also
put this info into my Outlook calender, is there a way that I can put
something in my Outlook Calender and have it automatically put it in my
spreadsheet. Or vice versa.
 
A

Anne Troy

Hi, Jason. I have a client who paid a good deal of money for us to develop a
custom solution for him. He uses his calendar to track time spent on
projects (past time spent instead of future appointments), and uses
Categories for the project names. He runs the application at the end of each
month, and it creates an Excel workbook that has all the detail, but is also
subtotalled by project. No, it does NOT go from Excel back to Outlook.
However, I can tell you that it will require VBA, and extensive VBA at that.
************
Hope it helps!
Anne Troy
www.OfficeArticles.com
 
Top