+ Reply to Thread
Results 1 to 9 of 9

Macro to save shared addin to personal addin folder

  1. #1
    Registered User
    Join Date
    11-03-2008
    Location
    Swindon
    MS-Off Ver
    XP Office 2002
    Posts
    7

    Macro to save shared addin to personal addin folder

    Hi,

    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. Reason: Subscribed

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    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.
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  3. #3
    Registered User
    Join Date
    11-03-2008
    Location
    Swindon
    MS-Off Ver
    XP Office 2002
    Posts
    7
    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.

    Thanks again.

  4. #4
    Registered User
    Join Date
    11-03-2008
    Location
    Swindon
    MS-Off Ver
    XP Office 2002
    Posts
    7
    Bumped up....

  5. #5
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    What you8 are suggesting will be very complicated. Why not just distribute the addin with instructions on how to install it?

  6. #6
    Registered User
    Join Date
    11-03-2008
    Location
    Swindon
    MS-Off Ver
    XP Office 2002
    Posts
    7
    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.

  7. #7
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    You can install an addin on a shared network drive, which is what I thought that you had originally.

  8. #8
    Registered User
    Join Date
    11-03-2008
    Location
    Swindon
    MS-Off Ver
    XP Office 2002
    Posts
    7
    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.

  9. #9
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    Glad it helped. Please mark the thread solved if you are happy with the result

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1