Adding a reference under VBA

[Robin Clay]

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]

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"