VBAToolKit SetUp

Software to install

To install VBAToolKit you'll need:

1. VBAToolkit (mandatory)
2. Git (recommended)
3. MZTools 3.0 (optionnal)

Other third part tools may interest you. See Third Part Tools

---

Git

VBA Toolkit promotes the use of Git for versioning.
Its use is not mandatory to work with VBAToolKit, but it is recommended. If Git is setup on your computer, VBAToolkit will initialize a git repository when you create a new project. If Git is not setup, VBAToolkit will just create the project without initializing the Git repository. You can download the executable Setup file from http://git-scm.com/download/win

When setting up Git, choose one of the option Run Git from the Windows Command Prompt or Run Git and included Unix tools from the Windows Command Prompt if you want VBAToolKit to nicely interact with Git. The safer option is to choose Run Git from the Windows Command Prompt. You could also install Cygwin on your PC to get full capabilities of Unix tools from the Windows Command Prompt.

VBA language and VBA projects are not cross platform. Choose the Checkout as-is, Commit as-is option.

---

MZTools 3.0

MZTools 3.0 for VBA is a free Add-In for the VBA IDE that provides useful features for writing VBA code. Its use is not mandatory to work with VBAToolKit, it is just an option you could consider. You can download the executable Setup file from http://www.mztools.com/v3/download.aspx

---

VBA Toolkit

1. Locate the Excel add-in file "VBAToolKit.xlam" in your VBAToolkit Folder, or download it from here.
2. Copy/paste it in the relevant folder :

• If you want VBAToolkit to be available to your user account, copy/paste this file into the add-ins subfolder of your %APPDATA% folder. Default path with Office 2007 and WinXP : C:/Documents and Settings/xxx/Application Data/Microsoft/AddIns

• If you want VBAToolkit to be available to every user on the machine, and if you have admin rights, you can copy/paste this file in the "Library" folder of your Microsoft Office installation.
Default path with Office 2007 and WinXP: C:\Program Files\Microsoft Office\Office 12\Library

3. Verify in your Excel preferences that the add-in is visible. Excel Home Button -> Excel Preferences -> Add-ins
4. Select "manage Excel add-ins" and press the "Go" button.
5. Activate VBAToolkit.
6. If all went well, you should see the VBAToolkit toolbar in the Add-In tab of Excel.