Re: Converting VBA (under Excel) to stand-alone

From: rmjflack <rmjflack@xxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Sun, 20 Jan 2008 10:42:01 -0800
Lines: 23

I have an app I developed using VBA under Excel (cos that and APL are the
only two languages I have available on my machine currently) and want to
migrate it to a stand-alone app (.exe file).

I have no idea how to go about this!
Worse, I have no idea where to look for help!

Can any one one point me in the right direction for guidance?
I am TOTALLY confused about the different version of VB that seem to be
around.
VBA, VBS, VB5 & 6, VS20008 for .NET (what is a .NET and why do i want one?
LOL)

This is not a web app, or client-server app, just a simple old PROGRAM (do
ppl not write programs any more?).

It does use worksheets as lazy way to display stuff, but Im told that can be
converted to Forms. Otherwise no Excel functionality required.
The windows file selector is a key component, not sure thats available in
VBS (the FileSystemObject does not seem to include it for some bizarre
reason).


How much time do you have?

Use it as opportunity to learn the new stuff. Download it for free. Code one
section at a time until you get it all done.

Alternatively, it's easy to put code in either Excel or Access to get rid of
the parent window. It will flash one time when your app loads, then go away
if you code it that way. Then your app will look like a standalone exe.

--
dgm
.

Loading