comp.lang.idl-pvwave archive
Messages from Usenet group comp.lang.idl-pvwave, compiled by Paulo Penteado

Home » Public Forums » archive » Active X with Excel VBA
Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend 
Switch to threaded view of this topic Create a new topic Submit Reply
Active X with Excel VBA [message #22526] Thu, 16 November 2000 00:00
efrans is currently offline  efrans
Messages: 8
Registered: June 2000
Junior Member
I am trying Active X (I appologize in advance ;) for the first time with
IDL 5.3 on Windows NT.

Basically I am attempting to run an example shown in the v.5 External
Development Guide book (pgs. 39-43). However, the example is for regular
Visual Basic and since I don't have access to that, I am using VBA with
Excel 97 (I know it keeps getting worse.;)

The first problem I encountered was that VBA didn't recognize the
Form_Load function. So I changed this to UserForm_Activate and the
function then was recognized on start up.

The next problem involves the lines that contain "hWnd". Namely,

n = IDLDrawWidget1.InitIDL(Form1.hWnd)
IDLDrawWidget1.SetOutputWnd(IDL_Output_Box.hWnd)

I get the following error while hWnd is highlighted:

Compile error: Method or data member not found.

I'm not sure what the problem is. I successfully added the
IDLDrawWidget Control 2.0 component and VBA seems to recognize the
methods and properties.

I know most of you don't want to deal with Active X and I don't blame
you. However, I'm curious to see if I can get this experiment to work
before I delve into using Active X with IDL and LabView.

Any help is greatly appreciated and thanks in advance!

- Eric Frans


Sent via Deja.com http://www.deja.com/
Before you buy.
  Switch to threaded view of this topic Create a new topic Submit Reply
Previous Topic: Re: histogram crashes (example code) thanks!
Next Topic: Re: histogram crashes (example code)

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ] [ PDF ]

Current Time: Wed Oct 08 13:45:51 PDT 2025

Total time taken to generate the page: 0.00507 seconds