×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

VBA to VB6

VBA to VB6

VBA to VB6

(OP)
If a form or module is created in VBA, can it be exported and then imported into a VB6 project?  

Thanks.

RE: VBA to VB6

A form or module is not created in VBA.  It is created in the Application which uses VBA as its underlying engine.  Forms are created in Word, Excel, Access, and VB6, all of which use VBA as their underlying engine.

So the question is how to move forms created in Access to forms in VB6, or vice versa, or forms from Excell into Access or VB6.

The answer is not very easily.  The standard set of controls that Access provides (textbox, combobox, etc) is not the same as the standard set of controls that VB6 provides, meaning that properties and events may not match up.  It's conceivable that you could write a program to analyze a form designed in access, and try to recreate that design in VB6, but it would be an arduous process, since not all of the control will matchup.  For example, VB6 does not have a subform control like Access does.  If you don't have too many forms, then manual may be the best option.  You can then cut and paste the actual code behind the forms, making sure that relavent event name match up, and you certainly can cut and paste entire standard code modules from one to the other.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources