VBA Reference Lost

[map367]

After I open a workbook in Excel 2010 and run a macro, Excel replaces the VBA references with version 14. Now users with Excel 2007 cannot run the vba code when they open the workbook.

How do I make the VBA references dynamic between both versions of Excel?

 

[Norie]

Does the code save the workbook?

 

[map367]

The code actually references Outlook Object library by creating Calendar appointments from excel