Move Calendar items to Excel using VBA

[Ross]

Hi,

Does anyone know, or have an example of the code I require
for writing a macro in VBA that'll take all appointments
between two dates and import them into an Excel file
that's already open?

The calendar is one which is broken down into various
people's names. So there's several calendars in effect.

I know you can do an export but it needs to be VBA, so
someone can click a button in Excel and the information
will collate.

Hope someone can help.

Thanks,

Ross