Correction:

It should be

XLApp.Workbooks.Open ("My Workbook.xls")

not

XLApp.Workbooks("My Workbook.xls").Open


Thx,
JP

On Jun 5, 10:39 pm, JP wrote:
It would need to run from Outlook, it just makes more sense that way
that when someone adds a calendar entry, the event code would pick it
up and start Excel.

Keep in mind this means you would need to install this code on every
users' machine that you want to receive this information from.

This should get you started. Place this code in the ThisOutlookSession
module of your Outlook. Then close and restart Outlook.

Private WithEvents CalItems As Outlook.Items