Business analysts use the BAM Add-In for Excel to define the events and data to be tracked, along with the logical groupings and aggregations of the tracked data views that users are able to access.
BAM Add-In for Excel requirements
You can run the BAM Add-In for Excel on any computer, whether BizTalk Server 2006 is installed on that computer or not. However, you must first install the files listed in the following tables for the BAM Add-In for Excel to work.
This table lists the required files if you are using Microsoft Office 2007. It also indicates where the files are installed locally and which program you should go to for the files (in parentheses).
|
File name
|
Version
|
Default installation location and where to get
|
|---|
|
Excel.exe
|
12.0.4518.1014
|
%ProgramFiles%\Microsoft Office\Office12
(Excel 2007)
|
|
Vbe6.dll
|
6.5.10.20
|
%ProgramFiles%\Common Files\Microsoft Shared\VBA6
(Part of the Office installation when you choose “Visual Basic for Applications” from Office Shared Feature)
|
|
Stdole2.tlb
|
5.2.3790.1830
|
%windir%system32
(Part of the Office installation when you choose “Visual Basic for Applications” from Office Feature)
|
|
Mso.dll
|
12.0.4518.1014
|
%ProgramFiles%\Common Files\Microsoft Shared\Office12
(Any Microsoft Office 2007 program)
|
|
Fm20.dll
|
12.0.4518.1014
|
%Windir%\system32
(Microsoft Office 2007)
|
|
Scrrun.dll
|
5.6.8827
|
%Windir%\system32
(Part of the Office installation such as “Microsoft Script Editor”
Or
Install Windows Script 5.6)
|
|
Mscomctl.ocx
|
6.1.95.45
|
%Windir%\system32
(Part of the Office installation: “Visual Basic For Applications”
Or
Visual Basic 6.0 Common Controls)
|
|
Msado15.dll
|
2.82.1830.0
|
%ProgramFiles%\Common Files\System\ado
(Installed by BizTalk Server
Or
Install MDAC 2.8 SP1)
|
|
Msxml4.dll
|
4.20.9841.0
|
%Windir%\system32
(Installed by BizTalk Server
Or
Install MSXML 4)
|
This table lists the required files if you are using Microsoft Office 2003.
|
File name
|
Version
|
|---|
|
Excel.exe
|
11.6560.6568
|
|
VBE6.dll
|
6.4.99.72
|
|
stdole2.tlb
|
5.2.3790.1181
|
|
mso.dll
|
11.0.6568.0
|
|
fm20.dll
|
11.0.6550
|
|
scrrun.dll
|
5.6.0.8827
|
|
MSCOMCTL.OCX
|
6.1.95.45
|
|
msado15.dll
|
2.82.1830.0
|
|
msxml4.dll
|
4.20.9818.0 (SP2)
|
Other Resources
Managing BAM