Adding a reference under VBA
 

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.

Adding a reference under VBA
 

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"

--
Regards,
Tom Ogilvy



"Robin Clay" wrote in message
...
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.