Oh I forgot.
if you want to have the macro at another computer is a bit more tricky. I advise aganist it because it might work in theory but in realy life it will probably hang quite often. you can however connect 2 xls files to each other if they are on the same network. Note that this in practice requires ActiveX. DDE requires that you are logged in to the BB. Doing that from a distant is doable by using SendKeys (but it is only doable in theory since it will work 1 out of 10 times). Needless 2 say I advice against. ActiveX does not require that you are logged in.
In sum if you are on the same network it is doable. However mind the legalities involved...
