Solved: Setting Available References

[ChrisB]

I'm looking to be able to control, via VBA, the references that are otherwise acessed in the VBE from the tools menu.

l want to create a process where a user has a workbook with many sheets. Some of these sheets are saved to a new workbook along with the associated VBA modules and then sent via Novell Groupwise to a manager for review.

The workbook the manager receives then has the code to allow them to send it on to a 3rd party for action.
On my machine this all works, but it fails at this point on any machine except mine as the 'Groupware type libarary' reference isn't set.

Can this be done in VBA?

Many thanks,
Chris

[mdmackillop]

Hi Chris
Welcome to VBAX
Have a look at this KB Item to see if it helps. There are another couple of related items by the same author.
If you need further assistance, Let us know.
Regards
MD

[ChrisB]

Many many thanks, that's exactly what I needed.