Excel macro to VB executable

[ccdubs]

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.

 

[ccdubs]

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.