Take Excel VBA to VB6?

[detroitpickles]

All,

Is it possible to get all of my Excel VBA stuff and open it in VB6? I need the code (of course) and the forms too. The code shouldn't be a big deal, even if it was a cut and paste, but what about the forms?


Thanks,

Mr. Pickles

 

[neilkonitzer]

You would have to completely re-draw and code your forms if you're going to convert your Excel app into VB6, or you can use the Excel Object in VB and interact with you Excel application using automation. Neil Konitzer
Freisoft

http://www.freisoft.com

 

[kylua]

I just imported a VBA form into VB6. It went into the designers folder.

I just added a little code, userform1.show referring to it, ran it and it worked.

The help file says:

Note The Microsoft Forms designer is included in all versions of Visual Basic, to allow forms created in Microsoft Office applications to be ported easily. Like all designers, the Microsoft Forms designer has its own run-time .dll. Using this designer in a Visual Basic project will therefore increase the memory requirements of the resulting executable.

So it can be done. What restrictions apply, I don't know.