Convert VBA to VB6...

[Cicatrize]

I have a rather large "application" that I've built into a spreadsheet at work (about 1200 lines of code, 4 forms, and code on a few spreadsheets).

I'd like to convert all this code and the forms into a VB6 project so I can have this application as an executable separate from the workbook, if possible.

I tried exporting the forms, but they show in the project explorer as Designers.

How can I do this?!

[stanleydgromjr]

Cicatrize,

A lot of information here: try searching Google for "Convert VBA to VB6".


Have a great day,
Stan

[royUK]

I don't think you will find this is easy, I don't think there is an easy way to create an exe file from a excel workbook.

[Cicatrize]

Cicatrize,

A lot of information here: try searching Google for "Convert VBA to VB6".


Have a great day,
Stan

I tried this and couldn't find anything.

[Cicatrize]

I don't think you will find this is easy, I don't think there is an easy way to create an exe file from a excel workbook.

All I need to do is export the forms into a VB6 form format and then copy the code over, but when I try to do this, it opens in VB6 as a Designer form, not an actual form.

Do you know of a way to load it properly??

[royUK]

They are not exactly the same and code is slightly different so I don't se how you can

[Bob Phillips]

All I need to do is export the forms into a VB6 form format and then copy the code over, but when I try to do this, it opens in VB6 as a Designer form, not an actual form.

Do you know of a way to load it properly??

You would best rebuild the forms from scratch, four isn't many. Most of the code will be the same, just note that it is Form_Load, not Userform_Initialize, and VB uses a different naming convention for controls (but you should be using a naming convention anyway).

[Cicatrize]

You would best rebuild the forms from scratch, four isn't many. Most of the code will be the same, just note that it is Form_Load, not Userform_Initialize, and VB uses a different naming convention for controls (but you should be using a naming convention anyway).

Yeah, I know more about VB6 than I do about VBA, so that won't be an issue. I was just wondering if there was an easy way to convert it. There are a LOT of controls on the main form.

[Bob Phillips]

I just tried a simple test.

I created a VBA form and exported it, and open the .frm file in a text editor. I had to change this line

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

and remove this line

Please Login or Register  to view this content.

and then it was virtually identical to a VB6 form. So I dragged it into my VB6 projectm, and it showed as a VB6 type form, but no controls showed. It seems the VB6 control positions are defined in the .frm file, so I just had to add some code to show then, like so

Please Login or Register  to view this content.

got it afresh, and all seemed well.

I emphasise that I tested this on a simple form but it seemed to work, and it should be simple to write some code to generate that extra control info from within VBA.

[Cicatrize]

Thanks, but I'd have to do that for all my controls, and it'd just be easier to start the whole project from scratch again. Oh well. Thanks for the help guys.

[Bob Phillips]

Thanks, but I'd have to do that for all my controls, and it'd just be easier to start the whole project from scratch again. Oh well. Thanks for the help guys.

I am talking about automating it, but it's your choice.