I know this is probably just wishful thinking, but I have a need to move an app from VB6 to VBA. The code moves relatively easily but can I reuse the 15 complex VB Forms to VBA or do I need to redo them? Some of the forms use flexigrid, and I'm not sure whether that is available in VBA forms. Here's hoping for a positive reply. Even if it's a "No", thanks in advance for any replies. Ian B
Ian B wrote: > I know this is probably just wishful thinking, but I have a need to > move an app from VB6 to VBA. The code moves relatively easily but > can I reuse the 15 complex VB Forms to VBA or do I need to redo them? > Some of the forms use flexigrid, and I'm not sure whether that is > available in VBA forms. > > Here's hoping for a positive reply. > Even if it's a "No", thanks in advance for any replies. > > Ian B Sorry, the answer is no, even if you didn't use a flexigrid. VB6 forms aren't binary-compatible with VBA forms. -- 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.
Jay Freedman wrote: > Ian B wrote: >> I know this is probably just wishful thinking, but I have a need to >> move an app from VB6 to VBA. The code moves relatively easily but >> can I reuse the 15 complex VB Forms to VBA or do I need to redo them? >> Some of the forms use flexigrid, and I'm not sure whether that is >> available in VBA forms. >> >> Here's hoping for a positive reply. >> Even if it's a "No", thanks in advance for any replies. > > Sorry, the answer is no, even if you didn't use a flexigrid. VB6 forms > aren't binary-compatible with VBA forms. What if they were compiled into a DLL, and invoked via exposed-class methods? Another thought might be to compile their basic functionality into OCXs and load those onto VBA forms? -- .NET: It's About Trust! http://vfred.mvps.org
"Ian B" <ian@(TakeOut)docspro.co.nz> wrote in message news:%23lG6fvwDJHA.4436@TK2MSFTNGP02.phx.gbl... >I know this is probably just wishful thinking, but I have a need to move an >app from VB6 to VBA. The code moves relatively easily but can I reuse the >15 complex VB Forms to VBA or do I need to redo them? > Some of the forms use flexigrid, and I'm not sure whether that is > available in VBA forms. > > Here's hoping for a positive reply. > Even if it's a "No", thanks in advance for any replies. If you need to use native VBA userforms without any external dependencies, then you need to redo them, and probably do a fair bit of redesign as well. VBA UserForms are far less capable than VB6 Forms. If you can make use of external ActiveX DLLs, I would recommend that you package up the forms into a series of classes and compile them into an ActiveX DLL and set a reference to it in your VBA project, as Karl suggests. Whether that will work for you depends I suspect on how much code you have put directly into the event procedures of your forms. -- Regards Jonathan West - Word MVP www.intelligentdocuments.co.uk Please reply to the newsgroup
