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 (for Office 2007-2010)

1. Download the last stable version of VBAToolKit.

2. Move VBAToolKit.xlam in the relevant Microsoft Add-Ins folder. For WinXP: C:/Documents and Settings/<UserName>/Application Data/Microsoft/AddIns if you want VBAToolkit to be available for your user account or C:/Program Files/Microsoft Office/<OfficeVersion>/Library if you want VBAToolkit to be available to every user on the system (you'll need to have admin rights). For Windows 7: C:/Users/<UserName>/AppData/Roaming/Microsoft/AddIns if you want VBAToolkit to be available for your user account or C:/Program Files (x86)/Microsoft Office/<OfficeVersion>/Library if you want VBAToolkit to be available to every user on the system (you'll need to have admin rights).
   Replace <UserName> by the session name of the user and <OfficeVersion> by the internal name of your Office version : Office11 for Office 2003, Office12 for Office 2007 and Office14 for Office 2010.

3. Open Excel and click on the Office Button at the top left of the Excel Windows, Then Click on Excel Options on the popup window to Open the Excel Options Window

4. For Excel 2007 or Excel 2010, go to the Macro Parameters and authorize the Access to VBA Model Object

5. Select Add-Ins then select Manage Excel Add-Ins and press Go

6. In the Add-In window you just opened, check the box near VBAToolKit to install it and use it with Excel

7. Now you can see the VBAToolKit Toolbar in Visual Basic Editor