VBA code to check for missing reference.

Does anyone have any code to check for a specific reference, whether it is missing? (SFDCExcelAddin)

The only examples I have found after extensive searching are for VB not VBA

I have code which creates menu items dependent on whether or not certain references are present.

You can use the VBProjects.References property of the workbook and test each item to see if it matches your criteria (SFDCExcelAddin).

Use a For Each loop

Please Login or Register  to view this content.

HTH

Thanks for the code. Unfortunately I am getting the following error:

Run-time error
programmatic access to visual basic project is not trusted

Searching on Google it seems that I would have to change the security on each pc by going to macro security, trusted publishers and enable "Trust access to visual basic project"

Sometimes Microsoft make you want to scream!