Hi,
I have an Excel Add-in toolbar, which I created using VBA. My system's
configuration is:
Platform: Win 2000, SP4
Excel Version: MS Excel 2000 (9.0.8960 SP-3)
Microsoft Visual Basic: 6.3, VBA: Retail 6.4.9972, Forms3: 11.0.6550
The Add-in includes the "Microsoft XML, v3.0" reference for XML data
management.
The toolbar is created dynamically each time the Add-in loads.
(The toolbar creation code is in the Workbook_Open event handler.)
The Add-in works fine on my machine, but not always on other users'
machines.
I have noticed one of the following problems when this Add-in is used
on other PCs (i.e. it is kept in the Microsoft Add-ins folder):
1. When a new instance of Excel is opened, the message "Unable to load
DLL" is seen.
If the user tries creating a new XML-based project (File->New Project)
using the toolbar,
the error message "User-defined Type not defined" is seen, pointing to
the VBA statement
"Public XMLDoc As MSXML2.DOMDocument30".
In the Project References, "MISSING: Microsoft XML, v5.0" is seen,
though the PC
on which the Add-in was developed used only v3.0 !
2. When a new instance of Excel is opened, the toolbar is displayed
without any error,
and all XML operations work fine. However, when an existing Excel
workbook is opened,
Excel crashes while loading the toolbar. (Rarely seen)
3. The toolbar loads correctly on opening Excel, a new XML project can
be created,
but on opening a user form, the error message "Automation Error....." is
displayed.
In cases #1 and #3 above, the problem may be resolved (on the PC in
which the problem occurs) by following these steps:
a) In the Add-in's Project References dialog, de-select the XML
Reference, then click OK to close the dialog.
b) Open Project References again, locate "Microsoft XML v3.0", select
it, then click OK.
c) Save the Add-in, and close Excel.
d) Re-open Excel.
I would be grateful if someone can help me resolve this XML issue.
Thanks,
Shankar
|
Similar Threads
