refrence annother workbook

[tame]

I think I can write the code myself, I just need to know how to refrence a different workbook from a drive on my network in my code.

I think I need to have the macro open the workbook in order to use it? How would I go about doing these things?

 

[onlyadrafter]

Hello,

have you tried using the macro recorder?

 

[tame]

wow! I don't know why I didn't think of that.


It's been a long day already, and it's only 10AM.

Thanks. Sorry for wasting your time.