|
Home > Archive > BizTalk Server Tools > June 2004 > Error opening BamEndToEnd.xls
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Error opening BamEndToEnd.xls
|
|
| L Nayak 2004-05-25, 11:38 pm |
| I am trying to run the sample BAM End-To-End. When I run
the setup.bat. I get the following error
Retrieving BAM Definition XML from Excel workbook ...
Failed to open BAM Excel workbook file BamEndToEnd.xls.
Object reference not set to an instance of an object.
I have verified that the .xls file exists in the
directory. It tried opening the file directly using Excel
and got the following Microsoft Visual Basic error message
"Compile Error In Hidden Module : Initialization".
Do I need to install anything at my end before I run ? Is
there an easy way to find out what it is missing. I have
installed everything as as outlined in the BizTalk
installation manuals.
Thanks
| |
| icross 2004-06-22, 7:13 am |
| Hi,
I had a similar problem and it was related to the version of MDAC I had installed on my machine.
The BAM.xls macros seem to only support ADO 2.7 and your machine probably only has ADO 2.8. Therefore, to fix the problem you need to update the Macro project or get MDAC 2.7 on your machine. (This solution will invalidate the MS digital signature, but this may not be a problem for you).
Instructions:
Open the problematic BAM.xls
Select Tools / Macro / Visual Basic Editor
Select the VBA project and when prompted for a password enter: Microsoft
Then choose Tools / References
Remove the missing reference Microsoft ActiveX Data Object Library 2.7
Go out of the dialog
Choose Tools / References again
Browse to C:\Program Files\Common Files\System\ado\msado15.dll and add a reference
The choose Debug / Compile VBAProject
The File / Close and Return to Microsoft Excel
This should now be working ok.
Hope this helps?
Cheers,
Ian Cross
Cassium Technologies Ltd. | |
| Urmila Singhal[MSFT] 2004-06-28, 7:28 pm |
| Please check whether you are using Excel XP or later.
Otherwise check for other dependencies:
Check the references by clicking on Tools->Macro->Visual Basic. When the
editor shows up, click on Tools->References. The customer will be asked for
password.
The password is "Microsoft".
This password is not meant to protect IP but to provide a layer of
protection against accidental tampering of the code which will invalidate
the digital signature.
The required dlls are:
DLL name Version
VBE6.dll 6.3.91.8 or later
Excel.exe 10.0.4524.0 or later
stdole2.tlb 3.50.5014.0 or later
mso.dll 10.0.4219.0 or later
fm20.dll 2.1.7017.1 or later
scrrun.dll 5.6.0.6626 or later
MSCOMCTL.OCX 6.1.95.45 or later
msado15.dll 2.71.9030.0 or later
msxml4.dll 4.0.9406.0 or later
--------------------[vbcol=seagreen]
cpmsftngxa10.phx.gbl!TK2MSFTNGXA01.phx.gbl!cpmsftngxa06.phx.gbl!TK2MSFTNGP08
.phx.gbl!TK2MSFTNGP10.phx.gbl[vbcol=seagreen]
Hi,[vbcol=seagreen]
installed on my machine.[vbcol=seagreen]
probably only has ADO 2.8. Therefore, to fix the problem you need to
update the Macro project or get MDAC 2.7 on your machine. (This
solution will invalidate the MS digital signature, but this may not be
a problem for you).[vbcol=seagreen]
Microsoft[vbcol=seagreen]
a reference[vbcol=seagreen]
--
icross
------------------------------------------------------------------------
Posted via http://www.webservertalk.com
------------------------------------------------------------------------
View this thread: http://www.webservertalk.com/message240410.html
[vbcol=seagreen]
This posting is provided "AS IS" with no warranties, and confers no rights.
EBusiness Server Team
|
|
|
|
|