PDA

View Full Version : Solved: Setting Available References



ChrisB
03-20-2007, 08:42 AM
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
03-20-2007, 11:04 AM
Hi Chris
Welcome to VBAX
Have a look at this KB Item (http://vbaexpress.com/kb/getarticle.php?kb_id=267) 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
03-21-2007, 03:13 AM
Many many thanks, that's exactly what I needed.