convert VBA to VB

[michaelji]

hi,

I am a new for VBA.

I built a program to run VBA successfully which call Microsoft Word function. More specifically, I use Word's open/save file function.

I found I have to open a Word in order to run that VBA.

Is there a way that I can convert that piece of VBA code to a standalone VB code without Word involved?

thanks,

Michael,

 

[dhulbert]

You canould but Asfar as I know you would need to get hold of a copy of MS visual basic, modify your code then compile it into an executable.

Much easier and cheaper to just open a copy of Word.



I love deadlines. I like the whooshing sound they make as they fly by
Douglas Adams
(1952-2001)

 

[fumei]

What kind of files are you opening and saving? If what you are doing is opening and saving Word files, then....Word has to be involved whether you have an VB executable, or a VBA compile.

There is no way to make your code stand-alone executable without something that makes executables, like VB.

Gerry