Convert Excel+VBE file to VBA Professional file

R

rixanna

I used VBE to develop a simple program by using Microsoft Excel as its
database. However, there are some limitations such as the file is in
..xls and cannot be saved as a .exe file.

How could I get the same result by using Visual Basic Professional?
What can I do to convert the file into VBA forms but still using Excel
as its database?

Do I have to develop the program again? Only when the whole program is
done did I realized that I can't save it as .exe file.

Any suggestion?
Thank you in advanced
 
B

Bob Phillips

That may be so, but why do you feel that you need to save it as an exe file?

You could develop it under VB, using a lot of your original code, but the
exe will not store the data, so you will need to store that somewhere,
either a text file, the registry, a database, or an Excel workbook, so this
will need re-working. Forms are different in VB to VBA so they will need
re-work. Also, if you use the Excel functionality within worksheets or
charts, you will have to interface to Excel, which will mean more work.

Depending upon the complexity of your application, moving to an exe file
will require an amount of work. Is the return worth the effort?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Top