Convert excel formulas from worksheets into standalone ie. databas

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

StevenS - 25 Sep 2007 08:00 GMT

We have written an extensive programme using excel & VBA. We use a
combination of calculations & lookups in excel for some of our database
equivalent functions & VBA to control loops, data entry etc.
Due to different versions of excel & trying to distribute our software to
different users we are finding that we need to make the software standalone.
Is there a way of converting existing formulas in excel into an equivalent
standalone ie database so we have an exe. file so we can distribute the
programme to any user and not be concerned about the version of excel they
are using. I am open to suggestions or if you need clarification i can
clarify. We are prepared to recode if required.

Signature

Reply to this Message

Bob Phillips - 25 Sep 2007 09:06 GMT

You could convert to a VB executable and a mdb database using SQL to access
the data, but it is going to be a lot of work changing all of the
calculations (i.e. re-writing you own functions), the lookups (ditto), and
presenting the data.

A better way IMO is to develop your Excel app on the lowest version that you
will be using in production. Backwards compatibility is pretty secure
(although they did drop FileSearch in Excel 2007).

Signature

HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

> We have written an extensive programme using excel & VBA. We use a
> combination of calculations & lookups in excel for some of our database
[quoted text clipped - 7 lines]
> are using. I am open to suggestions or if you need clarification i can
> clarify. We are prepared to recode if required.

Reply to this Message