Hard Code DLL Reference in VBA
Hi,
I've created a dll progress bar (in VB6) that i successfully use from excel 2003 VBA. The way i use it is that i have to reference it from tools-- references, etc.
I am providing this application to a number of users. As it would be a 'hasle' to go around to each and every user to reference the dll is there any way to 'hard code' the reference??
I 've copied the dll on the network and tried to reference it from there but it still does not work i have to go each and every time to re-reference it for a new user
any advice much appreciated,
regards,
Alex
|