Running and addin from a network Drive

**gyro11** · 05-06-2009, 10:53 AM

Hey,

I have created an addin containing a macro which i have put on a network drive (K:\MY ADDIN\addin.xlam)

When i go to add it in excel it asks me if i want to copy it to the addins folder (locally) to which i say no, but then it doesnt work, and then the next time i restart excel, it says it cant find the addin and displays the LOCAL path it is looking in to try and find it.

Any idea how i can have it look for this on the Network path as the addin needs to be shared and updated by several people

Thanks

gyro

**shg** · 05-06-2009, 12:52 PM

See if http://www.pcreview.co.uk/forums/thread-947055.php helps.

**gyro11** · 05-07-2009, 04:28 AM

Yup, thats worked a treat. Thanks very much

**xenos55** · 03-24-2016, 09:41 PM

Hi I have the similar issue.

My formula in the cell is

'C:\Users\xxxxxxxxxxxxx\AppData\Roaming\Microsoft\AddIns\countcolour.xlam'!CountCcolor('V:\1.0 CDPU\CDPU Attendance\[Consumer Support 2016.xlsx]Feb'!$AC$9:$AH$9,Sheet3!A1)

The add in are in local drive.

How to set it so in share drive all can have it

assume the share drive path is

\\ABC108\share04\abd\1.0 Abc\staff ot

what is the step I should take or do. I can't totally get the idea at the link . Thank you.

**FDibbins** · 03-24-2016, 11:56 PM

xenos55 welcome to the forum

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.