VB<->VBA interoperability

[kuhni]

Hi All,

I have a very general question regarding the interoperability of VB/VBA
applications.

I know that it is possible to create a form e.g. in Excel from which I
launch Word and then show the Excel form on top of Word.

But I cannot manage to show a form - which I have created in a
stand-alone Visual Basic application (using its VBA Editor) - on top of
Excel.

Does this make sense? Wouldn't you expect that there is no difference
between MS Office applications and a VBA macro in an external VB
application?

Any comments are very much appreciated!

Many thanks and kind regards,
Kuhni

 

[ng]

The problem you're having sounds like the forms don't agree with each
other. In VB, the forms are of one type, in Office they are of another
type.

T

 

[kuhni]

T, thanks for your thoughts on this!

Your comment sounds right, but on the other hand I am using an
integrated VBA editor to create the form I want to show in Excel, so
why shouldn't it work then? My other macros work with Excel as well...

Again thanks for any ideas on this!

Kuhni