Importing code from VB to VBA

[Rasm]

I have had good luck importing BAS files from Visual Studio - Is there a way to also export Userforms from VB6 and then import them to Excel.

 

[AMAS]

Seems to be the same as exporting .bas but they are .fm files.

AMAS

 

[Rasm]

I tried to import FRM directly - dont work - maybe I am out of luck

 

[AMAS]

Try right-clicking the form in the VBAProject window and then export. Then the exported .fm file should be importable to another project.

AMAS

 

[RoryA]

No - VB6 uses different forms from VBA.

 

[AMAS]

Thanks for the correction Roya. I keep forgetting that VB (like office features) changed from Excel 2003 to the 2010. I'm using Office 2010 which I believe uses VB 8 and the features may have changed over the years.

AMAS

 

[RoryA]

Vba forms are unchanged in 2010 (it uses vba7)

 

[Rasm]

Rory
If I build DLLs in VB6 - can I call them from xl2007 - I assume that should not be a problem. Do you know?
Thanks

 

[RoryA]

Yes, you can.

 

[Rasm]

Man - u a wealth of knowledge - thanks