Generating VBA forms 1

[peterkin9]

I have an interest in the transfer of AS/400 applications written in RPG to Visual Basic. Some while ago, I wrote a program that will convert an RPG screen format member into one or more VB forms. In many cases, it would be more convenient to convert the RPG into VBA instead of VB, but I do not know of a way of importing forms into VBA. Can anyone help please?

Many thanks

Peter Kinsman

 

[PaulTEG]

Hi Peter,

1st off - dunno RPG.

What format is an RPG Screen member?

;P

 

[peterkin9]

In the original question, I have omitted a crucial word.
I need to know if there is a way of importing Visual Basic forms into VBA - I have already done the conversion from RPG.

Peter

 

[PaulTEG]

Peter,

You can import Forms & Modules into VBA, but there is a word of caution in that Older versions of VB aren't supported by VBE, but now for the good news


Visual Basic for Applications only supports UserForm form objects. This error has the following cause and solution:

· You are trying to load a form from an earlier version of Visual Basic or a form from a current standalone version of Visual Basic.

It is probably easiest to redesign the form using the UserForm tools within Visual Basic for Applications. If you can save the form in ASCII format, you may be able to modify the form and import it. However, you must completely understand the formats and limitations of the various form packages.


HTH ;P