Auto Loading Add-in and Reference when open file

D

dwhitey1124

New Member
Joined
Oct 24, 2014
Messages
28
Hi everyone, I'm working on a file that requires an add-in to be installed and a reference be set. Right now I have to add the Treemap.xla as an Add-In then open the workbookand then open the VBA editor and under Tools->References, turn on CHARTMAKER. I would like to shares this file with friends/peers that are tech savy. Is there a way to automatically open the add-in and set the reference to CHARTMAKER whenever the file is opened? The location of the add-in will be "J:\Administration\Excel Team\x Misc\Add-ins\Treemap". Any help would be really appreciated. Thanks in advance.
 

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.
You must log in or register to reply here.

Similar threads

E
  • Solved
Auto Rename originating "opened" file name in the VBA code when "Saved" or "Saved As"
Replies
6
Views
591
emack1230
E
J
  • Question Question
GetObject returning an error if the file is already open
Replies
0
Views
690
JustGreat
J
E
  • Solved
[VBA] File saving does not work/new version not uploaded
Replies
4
Views
709
NdNoviceHlp
NdNoviceHlp
S
  • Solved
Coding for extra lines to the body of an auto email
Replies
3
Views
1K
SQUIDD
S
S
  • Question Question
Auto email sending when no data present
Replies
0
Views
609
sknight22
S

Forum statistics

Threads
1,223,228
Messages
6,170,871
Members
452,363
Latest member
merico17

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top