Add-in pathway problem

Jak

Well-known Member
Joined
Apr 5, 2002
Messages
807
I have created a few add-ins i.e. DuplicateHighlighter.xla which I have distributed to co-workers. The add-ins are e-mailed over with a series of instructions on where to save the add-in and how to load it in Excel. The problem that I have is that some co-workers are not as IT literate as others. Some times the PC has files and folders set to hidden and they can't follow the pathway i.e. C:\Documents and Settings\Jak\Application Data\Microsoft\AddIns as the Application Data folder is not visable. While other co-workers would be happier if the add-in was done automatically with an .exe approach. Once the add-in is in the desired folder the co-workers do not have a problem installing it.

I would appreciate some insight on how to make the add-in executable and load the add-in to the right folder as in the pathway posted would be slightly different for each user as their own name in the pathway i.e. Jak might be Bill or John etc.

All suggestions welcomed, Thanks
 

Some videos you may like

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

Scott Huish

MrExcel MVP
Joined
Mar 17, 2004
Messages
19,958
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
Not sure how to make it an executable, but add-ins don't have to be saved to that folder structure, they can be saved anywhere on the system as long as they are not moved, then you just Browse to the file when you install it through the Add-Ins menu.
 

Jak

Well-known Member
Joined
Apr 5, 2002
Messages
807
Hi Hotpepper

The user can't just save it to their hard drive as they are restricted from doing so by the companys ICT policy or things would have been a lot easier. Therefore I need them to save the add-in to the add-ins folder. No idea about .exe files myself or a self extracting programs, hence the post. Thanks for your response.
 

Jak

Well-known Member
Joined
Apr 5, 2002
Messages
807

ADVERTISEMENT

BTT
 

bandit_1981

Board Regular
Joined
Aug 17, 2005
Messages
201
You could use winrar to compress teh addin and make it self extracting into the correct folder path
 

Jak

Well-known Member
Joined
Apr 5, 2002
Messages
807

ADVERTISEMENT

Hi bandit_1981

I thought about Winrar, WinZip etc but most users don't have these programs on their PC's and they would not be able to download them because of restrictions in ICT Policy. Cheers for the input. What i have been thinking about is a .bat file to go with the add-in but am still stuck on how to code it to move or copy the add-in to the right directory! Any thoughts or sample code?
 

Scott Huish

MrExcel MVP
Joined
Mar 17, 2004
Messages
19,958
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
How are they able to save your spreadsheet if they are not allowed to save anything?

Why will they not allow them to save anything but will allow them to enable macros?

Why not just talk to the IT department, tell them what you need and why and work out a reasonable solution, rather than trying to sneak your add-in on their system.

Or if they are allowed to save your spreadsheet, just include the add-in code in the workbook instead of having to load it as an add-in.
 

Jak

Well-known Member
Joined
Apr 5, 2002
Messages
807
Hi HOTPEPPER

Its not a case of sneaking an add-in onto a pc as I have distributed many add-ins to co-workers over the last few years. Part of my job is to find solutions to time demanding tasks which I usually do with Excel macros. Its a case of getting the add-in to the add-in folder. While you are able to save things to your hard drive the ICT policy asks that you not do so, perhaps it is not backed up on the server!!! Not really sure what the reason is. WWW is greatly restricted so downloading programs is a big no no hence anyone who did not have WinRar or WinZip etc installed before the policys were implemented would not be able to download them.

I think I will have a word with the ICT Team today as you suggest and see if they can set up a shared network folder to dump the add-ins into and use a bit of code to install them i.e something like this but in a .bat file.

Code:
Sub Addininstaller()
Dim oXL As Object, oAddin As Object
Set oXL = CreateObject("Excel.Application")
oXL.Workbooks.Add
Set oAddin = oXL.AddIns.Add("G:\JaksAddIns\DuplicateChecker.xla", True)
oAddin.Installed = True
oXL.Quit
Set oXL = Nothing
End Sub

Thanks for your input Hotpepper
 

Watch MrExcel Video

Forum statistics

Threads
1,118,452
Messages
5,572,209
Members
412,448
Latest member
ManuW
Top