Cannot Import/Export UserForms Between VBA and Visual Basic

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

VBA2007 - 03 Dec 2007 12:05 GMT

You cannot import or export UserForms or Forms between Microsoft Excel and
Microsoft Visual Basic.

http://support.microsoft.com/default.aspx/kb/213551

But I have to import VB6 Form to VBA. I need to test some examples in VB 6.
VB 6 is not supported. VBCCE 5 is too old.
Is it possible for users to convert Forms?
Are there convertion utilities?

Reply to this Message

Jay Freedman - 03 Dec 2007 14:48 GMT

> You cannot import or export UserForms or Forms between Microsoft
> Excel and Microsoft Visual Basic.
[quoted text clipped - 5 lines]
> Is it possible for users to convert Forms?
> Are there convertion utilities?

You might as well say "I have to fly by flapping my arms". In the same way,
trying to use VB6 forms in VBA Will Not Work. There is no conversion.

The reason is that VBA Userforms and VB6 forms use different binary formats
and different support libraries.

You will have to build new Userforms that look and act like the ones in VB6.

Signature

Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

Reply to this Message

VBA2007 - 03 Dec 2007 15:16 GMT

Yes, but there are conversion utilities from VB 6 to VB.NET (2005) - free and
commercial. And for forms too.

I found:
http://www.codeguru.com/forum/archive/index.php/t-395257.html

>There are some utilities that claim to be able to do this...

>I never really thought anything of it. I followed a couple of links on a Rent-A-Coder >project to clone a VBA-VB and VB-VBA converter, but I don't remember either of >the product names.

Where? I know that VB 6 and VBA forms are not 100% compatible. But I need to
try.

Reply to this Message