Excel 2007 References issue

[Guest]

I am making some changes for Excel 2007 compatibility to an old addin that
has been around for several years. I am running into a problem where Excel
2007 does not seem to be able to open References (in my case, to my addin)
that were previously saved for a Workbook.

For instance... create a blank workbook and a blank addin. Set a reference
within the workbook to that addin. To do this, in the IDE go to
Tools>>References and locate the addin and check it off. You will see in the
Workbook that a References folder is created with that reference in it. If
you save the workbook and reopen it, the reference is missing. Or at least
this is happening for me...

Anyone else see this behavior and could give me advise on it?

 

[Jim Rech]

I find that XL2007 saved workbooks keep references to an add-in if it's
saved in XLS format or if it has a VB project and is saved in XLSM format.
In other words if the workbook is saved in the macro free XLSX format or is
saved in XLSM format but doesn't have a module (empty is okay) the reference
is lost.

--
Jim
|I am making some changes for Excel 2007 compatibility to an old addin that
| has been around for several years. I am running into a problem where
Excel
| 2007 does not seem to be able to open References (in my case, to my addin)
| that were previously saved for a Workbook.
|
| For instance... create a blank workbook and a blank addin. Set a
reference
| within the workbook to that addin. To do this, in the IDE go to
| Tools>>References and locate the addin and check it off. You will see in
the
| Workbook that a References folder is created with that reference in it.
If
| you save the workbook and reopen it, the reference is missing. Or at
least
| this is happening for me...
|
| Anyone else see this behavior and could give me advise on it?