mapkn
03-03-2009, 03:29 PM
Hello All,
I have an xla which is to be used with a particular Excel workbook. There are also various VBA modules which should reference this xla in order to function properly.
In order to make sure that the correct xla is being referenced by the VBE, I want to:
1) remove all the existing references to the VBA project (even if they are not 'MISSING' and
2) add reference to this particular xla when the workbook is opened (using the Workbook_Open procedure).
I know how to part 2), but am having problems with part 1). I'm sure this must be something someone has seen before so would be very grateful for any help.
Regards,
Mitul
I have an xla which is to be used with a particular Excel workbook. There are also various VBA modules which should reference this xla in order to function properly.
In order to make sure that the correct xla is being referenced by the VBE, I want to:
1) remove all the existing references to the VBA project (even if they are not 'MISSING' and
2) add reference to this particular xla when the workbook is opened (using the Workbook_Open procedure).
I know how to part 2), but am having problems with part 1). I'm sure this must be something someone has seen before so would be very grateful for any help.
Regards,
Mitul