Hi all,

Is it possible to take the VB code from an Excel macro and put it into a VB
compiler and make a VB executable?

The code I have is not excel specific, it is basically opening and writing
to text files with data sourced externally. At the moment Excel is used as
an intermediate program to obtain data and write it to the file. This takes
a lot of resources and doesn't cycle fast enough (it even slows the system
clock).

Any info is appreciated.

Patrick,

I don't actually have a VB compiler yet. And I can't justify buying one at
the moment as this is likely to be a one off.

Can you recommend a freeware or shareware compiler?

As you can probably tell I am novice at VB programming. I have a little C
experience from my Uni days but I need to do this in VB as it will save a
lot of time.



"Patrick Molloy" wrote in message
...
Absolutely you can.
Open VB (I assume VB) and copy your code from the Excel module directly to
the VB module. You'll probably want to tidy up the code, but it'll be
easier
than you might imagine.

A quick tip...drag the code module from Excel IDE to the desktop, then you
can drag from the desktop into the VB6 IDE.

--
Patrick Molloy
Microsoft Excel MVP
----------------------------------
"ccdubs" wrote in message
...
Hi all,

Is it possible to take the VB code from an Excel macro and put it into a
VB
compiler and make a VB executable?

The code I have is not excel specific, it is basically opening and
writing
to text files with data sourced externally. At the moment Excel is used
as
an intermediate program to obtain data and write it to the file. This
takes
a lot of resources and doesn't cycle fast enough (it even slows the
system
clock).

Any info is appreciated.