VBA macro to .exe

Hello experts,

Is it possible to convert a VBA macro into a standalone .exe file?

I don't want the hassle of launching Microsoft Outlook (where the Macro is located) before launching the macro (which only does Windows file manipulation without the need of Outlook's features).

I do not have a copy of Visual Basic.

Sean
LVL 3
sow56091Asked:
Who is Participating?
 
gabesoSolution ArchitectCommented:
You could use VBScript to manipulate the file system: This would then require a .vbs file containing a vbscript application to do what you want.

In VBScript there is the FileSystemObject which will let you do any file or folder manipulations you want.

Then you just run with:
  c:> cscript myscript.vbs

or similar

If you give me the 'macro' definition I could convert it into a vbscript app for you..

0
 
SibishCommented:
Hi,

You can convert your VBA macro into a stand alone application, but you need to have VB. Conversion will be simple.

Regards,
Sibish.K.Abraham
0
 
sow56091Author Commented:
Sorry for the delay guys, but thank you both for your input.

Sean
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.