RE: Excel Upload to iSeries with cwbx.dll

Hi,

Tools/References is grayed out because your VBA project is currently
running and threw an exception on the cwbx.As400system type. You're
right, it can't find it because it hasn't been referenced in your
project. Without referencing any DLLs the only types your project knows
of are the standard ones like integer, string, double, Boolean, etc. It
is also aware of Excel specific types such as workbook, worksheet since
this is an Excel VBA project.

Start up Excel and press ALT + F11. Goto tools/references and browse
for cwbx.dll.

The way that the VBA and VB6 runtimes work is you have to declare your
variable with DIM then you have to initialize it with SET. The newer
.NET framework has a short hand for this: Dim as400 as new
cwbx.AS400System(). This does the declaration and initialization with
one line.

C:\Program Files\IBM\Client Access\Shared contains many DLLs. Cwbx.dll
happens to be an ActiveX library which exposes the functionality of the
other C++ DLLs in that folder to COM capable software such as MS Office.

What is it that you're trying to accomplish?

How to access the ActiveX topic:

1. Ensure that the Programmer's Toolkit is installed (see Install
the Programmer's Toolkit).
2. Launch the Programmer's Toolkit (see Launch the Programmer's
Toolkit).
3. Select the Overview topic.
4. Select Programming Technologies.
5. Select ActiveX.


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Eftimios
Pantzopoulos
Sent: Sunday, March 28, 2010 11:01 PM
To: midrange-l@xxxxxxxxxxxx
Subject: Excel Upload to iSeries with cwbx.dll