• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 154
  • Last Modified:

please before to post me dont smile about my question...

... i am a perfect newbie in VB 6.0....
my question:
admitting i have a useform conpletly cleared but with butto, textbox aecc... created with vba for excel, i can import this userfornm without error in a project in vb 6.0, or before to import in vb a must convert it?

my problem in effect is... i have maked a milion application in VBA Excel and Access... and i dont wuont to rewrite entire code and userform because i would want to initi to use VB for seriou application.:-)


0
sal21
Asked:
sal21
  • 3
  • 3
  • 3
  • +2
1 Solution
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
AFAIK you cannot import forms made in Excel or Access into Visual Basic.  

Sorry.
-Jim
0
 
sal21Author Commented:
good existis a converter?
Or i create new all my userform to use in VB?
0
 
sal21Author Commented:
Jim,
existis a converter?
Or i create new all my userform to use in VB?

 but i would want to import only the graphic part of useform without code and routine in VBA for excel...
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
If there is some kind of third-party converter, you would be able to find it with a Google search, but last I remember there is none, or at least none that guarantees 100% conversion success.

>but i would want to import only the graphic part of useform
Define 'graphic'.  If the graphic is linked you should just be able to find the file.
0
 
aianrnoensCommented:
I think he meens the layout and design of the form.  Not a picture
0
 
sal21Author Commented:
i am sorry dut graphic for me is button, textbox, check box ecc...
0
 
GrahamSkanRetiredCommented:
You can export the form as a file from the VBA editor, and add the file into your VB(6) project.

It will be shown in the Project pane under 'Designers' rather than under 'Forms', and it will still be a UserForm. The controls will still be Forms 2.0 controls and not intrinsic VB controls.

Note that most experienced VB and VBA users would not even try this.

0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
>You can export the form as a file from the VBA editor
GrahamSkan  - Where, and on which version?  Just curious.  
0
 
GrahamSkanRetiredCommented:
In VBA editor there is a File/Export File...  menu item, at least there is in Word. I admit I haven't checked the other two applications.
0
 
jkaiosIT DirectorCommented:
This is an "Access to Visual Basic 6 Object Converter"

http://www.iriesoftware.com
0
 
GrahamSkanRetiredCommented:
I have now checked Access and Excel.

Excel acts like Word, but Access exports a UserForm file as a Class file. It can still be added into a VB6 project, but only the code is visible.

I have use Option Compare in some forms and note that that statement is illegal in VB. Of course it could be removed, but that coould mean that functions that rely on it do not work as expected.

sal21,
Have you considered leaving the forms in their applications and using COM (OLE Automation) to run them in VB?
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 3
  • 3
  • 3
  • +2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now