I am using VBA to generate a Notes message, attach a file and send to a
specified person. Currently I am running Notes v6.5 but most of my audience
for this app is using an earlier version. My problem is this: The reference
to the Lotus Notes Automation Classes for my version points to C:\Program
Files\Lotus\Notes\Notes32.tlb whereas my audiences' points to
C:\Lotus\Notes\Notes32.tlb
Excel does not seem to be able to find the appropriate version for the
machine it is running on. Is there a way I can code the proper .tlb location
in VBA depending on the version of Notes someone is using? Or, perhaps, if
the Notes32.tlb does not exist in one place, check another?
Much appreciative of any direction you can give me! patrick