Convert code to .exe file

[deltaair]

How can i convert some VB code to a standalone .exe program.

 

[longhair]

deltaair,
vb or vba?
if vb then you would need a compiler - such as vb version 6 or vb.net from ms.
if you mean vba then i'm not sure if it can be done at least into an .exe.
perhaps a bit more info?
regards,
longhair

 

[deltaair]

Thanks for replying,

I have some code in excel which I want to make a standalone .exe program because it doesn't need excel really. i don;t know if thats vb or vba. Please let me know how i can do this.

Thanks

 

[longhair]

deltaair,
that is vba. as far as i know it needs excel. that is to say the language is part of excel, you need excel for it to run. what you would need to do to make it stand alone is to convert it to vb6 or vb.net or vbscript or a batch file etc. can you post the code that you want to make an .exe? perhaps if we saw it we could point you in the correct direction.
regards,
longhair

 

[deltaair]

Its basically reading/ finding replacing text in text files and copying / deleting them from folders etc.

Here's what the code looks like

Const pathname = "C:......."
Const filename = "fname.txt"

Public Function replaceAll(pathname, filename, String1, String2) As String.....
This replaces some text within the text file.

Then copies into a directory using
FileSystemObject.CopyFile

I have a subroutine...
Public Sub ChangeFile()
Call ReplaceAll(........)
End Sub

Sorry but just as soon as i posted this, a lot of my code vanished into thin air because of excel,....That's the best I can provide... Any info is appreciated.

 

[SkipVought]

Hi,

VBA code is a subset of VB. It can be compiled in a VB compiler.

If you have no references to application objects, you can compile in VB with no references to other object libraries.

Export the module from the application.

Import the module into the VB editor and compile.

Skip,

_{[red]Be Advised![/red]
The band of elderly oriental musicians, known as Ground Cover, is, in reality...
Asian Jasmine!}

 

[longhair]

deltaair,
if all you are doing is replacing text and moving files then do a search in the following forums:

http://www.tek-tips.com/threadminder.cfm?pid=271

http://www.tek-tips.com/threadminder.cfm?pid=329

there should be numerous examples.
after you have your scripts created you will then need to manually run them (double click) or set them up as a acheduled task.
regards,
longhair