Adding a reference under VBA

Robin Clay · Oct 14, 2003

Greetings !

And, having copied this sheet into a new workbook, how do
I then add to the new workbook a Reference to the old
workbook ?

I can do it manually, but I can't record my steps as a
Macro.

Tom Ogilvy · Oct 14, 2003

Explain how you do it manually - then we might have a better idea of what
you exactly mean by reference.

If you mean a reference added in Tools=>References in the VBE,

http://support.microsoft.com/?id=160647
XL97: How to Programmatically Create a Reference

http://support.microsoft.com/?id=156882
XL97: Err Msg: "Name Conflicts with Existing Module"

Adding a reference under VBA

Robin Clay

Tom Ogilvy