Convert Excel+VBE file to VBA Professional file

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

rixanna - 13 Nov 2006 06:19 GMT

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

Reply to this Message

Bob Phillips - 13 Nov 2006 09:45 GMT

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?

Signature

HTH

Bob Phillips

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

> 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
[quoted text clipped - 9 lines]
> Any suggestion?
> Thank you in advanced

Reply to this Message

rixanna - 15 Nov 2006 07:53 GMT

Hello Bob,

You make me think twice.
Anyway, thanks a lot.

Reply to this Message

Rate this thread: