Results 1 to 3 of 3

Thread: Converting VBA code into an Executable

  1. Jan 4th, 2006, 02:53 PM #1
    rmurgz
    rmurgz is offline

    Thread Starter
    New Member
    Join Date
    Jan 2006
    Location
    UK
    Posts
    2

    Converting VBA code into an Executable

    Hi!

    We have a number of Excel workbooks with an array of code contained within them. We would like to develop a number of common utilities and I was wondering whether it was possible to create an Executable binary that could be deployed onto a machine directly.

    Does anyone have any experience of this process? What tools and other factors should I consider?

    Many thanks!

    R
    Reply With Quote Reply With Quote
  2. Jan 4th, 2006, 05:35 PM #2
    opus
    opus is offline
    I don't do your homework! opus's Avatar
    Join Date
    Jun 2000
    Location
    Good Old Europe
    Posts
    3,863

    Re: Converting VBA code into an Executable

    Since VBA is a part of EXCEL (or Word) you CAN NOT create .EXE-type files. The code developed is only usable with the .XLS-files it belongs too.
    You're welcome to rate this post!
    If your problem is solved, please use the Mark thread as resolved button

    Wait, I'm too old to hurry!
    Reply With Quote Reply With Quote
  3. Jan 4th, 2006, 06:23 PM #3
    RobDog888
    RobDog888 is offline
    Ex-Super Mod RobDog888's Avatar
    Join Date
    Apr 2001
    Location
    LA, Calif. Raiders #1 AKA:Gangsta Yoda™
    Posts
    60,709

    Re: Converting VBA code into an Executable

    Only if your running the Developer version of Office can you compile vba code into exe's.
    VB/Office Guru™ (AKA: Gangsta Yoda™ ®)
    I dont answer coding questions via PM. Please post a thread in the appropriate forum.

    Microsoft MVP 2006-2011
    Office Development FAQ (C#, VB.NET, VB 6, VBA)
    Senior Jedi Software Engineer MCP (VB 6 & .NET), BSEE, CET
    If a post has helped you then Please Rate it!
    • Reps & Rating Posts • VS.NET on Vista • Multiple .NET Framework Versions • Office Primary Interop Assemblies • VB/Office Guru™ Word SpellChecker™.NET • VB/Office Guru™ Word SpellChecker™ VB6 • VB.NET Attributes Ex. • Outlook Global Address List • API Viewer utility • .NET API Viewer Utility •
    System: Intel i7 6850K, Geforce GTX1060, Samsung M.2 1 TB & SATA 500 GB, 32 GBs DDR4 3300 Quad Channel RAM, 2 Viewsonic 24" LCDs, Windows 10, Office 2016, VS 2019, VB6 SP6
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width