Duncan,
From your description it sounds likes the Excel worksheet part of is for
data/setting storage and your "program" is mainly form based. If you first
move data/setting part out of Excel (to ini file, DB etc), you will be most
of the way towards compatibility.
Whilst your forms may appear similar in VBA as they do in VB5/6, they are
not directly equivalent. You can however save your VBA forms as text, then
compare that to a similar form created in VB and compare the difference; or
design them from scratch in VB.
You should not have too much difficulty converting, as the logic of
sub/functions will remain the same.
Of course I have no idea what you achieve with you app, but it's certainly
feasible.
...As long as you get a copy of VB.

NickHK

"Duncan" wrote in message
ups.com...
Hi Guys,

I have always wondered, being fairly new to programming, how possible
it is to get something ive made in excel vba and re-create it in vb6 or
similar to make a standalone program?

The main reason is that I have made a menu system and data input
program through forms in vba but the fact that its tied to a
spreadsheet ties it down a bit, i would love to be able to remove it
from the spreadsheet and make it stand on its own. It uses the
spreadsheet to hold the data but im sure it could do all the same stuff
faster by just accessing a database instead of being within one.

I think VB would be the best option for me as i am learning vba
commands and it would be brill if i could easily take my vba code and
compile it in a vb project.

is this dream stuff? would i need to write it all again?

Duncan