Experimental Physics and
Industrial Control System

"Mark Rivers" <[email protected]> · Mon, 23 Oct 2006 11:21:15 -0500

Bill,

I have not used VBA, only VB.  Can VBA call routines in DLLs?  If so,
then I have an ezca.bas file that lets VB call CA through the ezca
interface.

Here's a snippet of code from ezca.bas

Public Declare Function ezcaGet Lib "ezca.dll" _
   (ByVal pvname As String, _
    ByVal ezcatype As Byte, _
    ByVal nelem As Long, _
    ByRef data As Any) As Long

Will such code work in VBA?

Mark Rivers

> -----Original Message-----
> From: Bill Nolan [mailto:[email protected]] 
> Sent: Monday, October 23, 2006 10:54 AM
> To: Tech-Talk
> Subject: Attaching VBA and ActiveX Controls 
> 
> Hi all,
>     I have been fumbling around with getting a vendor supplied control
> to integrate with the rest of my epics controls. I have learned enough
> VB and Windows to understand what I am working with, I hope.
> The vendor supplies a very nice instrument control program, which only
> has a VBA ( VB for Applications ) interface to it.
>     The interface is nice and simple, already for use as a BO or Sub
> record as part of an IOC, or to act as a CA client but I can not ( as
> far as I know) import a Com-object in to VBA nor will it give me a Dll
> and header file to link in to my epics App.
> Has any one solved this sort of problem before ?
> Or am I missing something simple that would let me bring in the Ca
> libraries to my VBA environment .
> 
> The second part is I hope much less complex,
> I seem to remember hearing that it is possible to link in ActiveX
> libraries (.ocx files) in to win32 native epics apps. Does 
> any one have
> an example of how to do it ? Or the patients to explain how.
> 
> --Bill
> P.S. many many thanks to Kay and others who made the native 
> win32 build
> work so well.
> 
> -- 
> Bill Nolan
> Washington University Medical School
> Department of Biochemistry
> 4566 Scott Ave.
> Mail Stop 8231
> St. Louis, Mo 63110
> 1.314.362.4445 Fax 1.314.362.7183
> 
> 

Experimental Physics and Industrial Control System

Experimental Physics and
Industrial Control System