I have setup a worksheet that uses Microsoft activex data object 2.7. When I run it on my machine it works ok, but when I run it on another machine it fails until I setup the data object on that machine. Is there a way of automatically setting the data object when the worksheet is opened please.
Thanks in advance
Thanks in advance