Macro to save shared addin to personal addin folder
I have an addin in a shared folder which was created by someone else. (it is a user form). I need to create a macro which will go to its existing folder and then save it in the users personal addin folder also picking up their user id. There will be about 100 users so easier this way than going round doing it for them.
So I suppose the query is three fold.
1, pick up the addin and save it in a personal addin folder.
2, Find the username as part of the path file. For instance my personal would be:
"C:\Documents and Settings\O033116\Application Data\Microsoft\AddIns"
The "O033116" is where I will need a search completed to obtain the user id.
The addin is called ServiceCredt.xla
3, Activate the installed addin.
The reason I want it this way is so the user is unable to access any of the code and we are in control.
I hope this makes sense!!!!
Thank you all in advance.
Last edited by MrStyx; 12-31-2008 at 10:18 AM.
Why will that prevent anyone accessing the code? The only way to do that is to protect the VBA Project
Open the VB Editor & select the addin.
Go to Tools -> VBAProject properties, lock the project for viewing, and enter a password.
Last edited by royUK; 12-30-2008 at 10:31 AM.
Ah yes I have noticed that now too. Sorry.
Once I have password protected do you have any thoughts on the rest. Obviously when you have time.
What you8 are suggesting will be very complicated. Why not just distribute the addin with instructions on how to install it?
Did think of that just hoped there may be a solution from you very kind Guru's. If this looks like it will be a complicated thing then I will follow your advice and distribute with instructions. Thank you for you assistance.
You can install an addin on a shared network drive, which is what I thought that you had originally.
I did have the addin in the shared drive just thought it would be better on the users personal folder. But if it does not make any difference then I will just send out the instructions. Thanks for your quick responses royUK. Much appreciated.
Glad it helped. Please mark the thread solved if you are happy with the result
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1