PDA

View Full Version : Can I convert Excel VB to VB6.0?


RedSoxFan
02-08-2002, 11:35 AM
I have an excel VB program that I would like to make available to someone who doesn't have excel. I heard that I can't make an executable file out of excelVB. I was wondering if someone knew of a way to convert Excel VB to regular Visual Basic (and then I could make an .exe file). I programmed it in Excel VB so I could make changes to it at home also (where I have Excel VB but not VB6.0).

I can copy and paste the code, but I can't do the same with my form and the objects in it. Also, I'd have to rework the code that stores information in the worksheet.

I doubt there's some utility out there that would do this, but I thought it'd be worth it to ask.

urysohn
02-08-2002, 11:56 AM
I don't think you'll find a utility because much of the code just won't translate. Any code that doesn't refer to your spreadsheet will probably copy straight over, however. But I think you're looking at a manual process.