VBA macro to .exe

Posted on 2005-04-17
Last Modified: 2008-03-17
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.

Question by:sow56091
    LVL 9

    Accepted Solution

    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..

    LVL 1

    Expert Comment


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

    LVL 3

    Author Comment

    Sorry for the delay guys, but thank you both for your input.


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    A short article about a problem I had getting the GPS LocationListener working.
    Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
    In this fifth video of the Xpdf series, we discuss and demonstrate the PDFdetach utility, which is able to list and, more importantly, extract attachments that are embedded in PDF files. It does this via a command line interface, making it suitable …
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now