Can I Convert ExcelVB code to an .exe file OR into VB6.0 code?


Posted by Todd on February 07, 2002 7:42 AM

I have an excelVB program that uses forms only, but stores/retrieves data from a sheet in the workbook. I want to allow people without Excel to run the program. I also have VB6 on my computer (I originally didn't write the program in VB6 because I wanted to work on this at home where I have Excel but no VB6), but I found you can't "copy" the form.. and I'd have to reword the code that stores/retrieves the data. But maybe there is a utility out there that will do it for me? Obiously creating an .exe file directly from excelVB would be most ideal, but I heard you can't do that.
Any ideas? Thanks in advance.



Posted by Jack in the UK on February 08, 2002 4:53 PM

No Excel uses bas and cls files, nott exe or com VB6 will so VBA (Excel and VB or not the same) But SOME VB commands will work in VBA be careful [NT]