Results 1 to 5 of 5

Thread: Can VBA convert to .EXE?

  1. Jan 15th, 2004, 03:59 AM #1
    Goh
    Goh is offline

    Thread Starter
    Fanatic Member
    Join Date
    Jan 2004
    Posts
    908

    Can VBA convert to .EXE?

    can VBA for example in excel convert to .exe?
    Reply With Quote Reply With Quote
  2. Jan 15th, 2004, 04:40 AM #2
    Matt_T_hat
    Matt_T_hat is offline
    Fanatic Member Matt_T_hat's Avatar
    Join Date
    Dec 2001
    Location
    '76 Male Body Evil-Errors: 666
    Posts
    774

    no

    for that you would require VB6 or VB.NET
    ?
    'What's this bit for anyway?
    For Jono
    Reply With Quote Reply With Quote
  3. Jan 23rd, 2004, 05:03 AM #3
    biswajitdas
    biswajitdas is offline
    Banned
    Join Date
    Jul 2003
    Location
    New delhi
    Posts
    143
    How can you convert vba into exe.

    what i understnd he wants to write a separte things in excel and he convert into exe


    das
    Reply With Quote Reply With Quote
  4. Jan 23rd, 2004, 05:26 AM #4
    si_the_geek
    si_the_geek is offline
    Super Moderator si_the_geek's Avatar
    Join Date
    Jul 2002
    Location
    Bristol, UK
    Posts
    41,974
    vba cannot create exe's.

    it is similar to VB6, so if you have VB6 you can copy the code and make alterations - but to be honest, in most cases it is better to start again as several important methods have very different syntax.
    (Microsoft MVP from July 2007 to June 2017) . . . . . . . . . . Hitchhiker's Guide to Getting Help at VBForums

    Database Development FAQs/Tutorials (updated May 2011) (includes fixing common DB related errors, and [VB.Net] ADO.Net Tutorial, and [Classic VB] ADO tutorial /further steps)
    other useful DB bits: . Connection strings (alternative copy).•. MDAC/Jet/ACE downloads .•. SQL Server downloads .

    Classic VB FAQs (updated Oct 2010) (includes fixing common VB errors)
    some of my Classic VB bits: . Tutorial: How to automate Excel from VB6 (or VB5/VBA) .•. SQL 'Select' statement formatter/checker .•. Convert colour number to colour name .•. FlexGrid: fill from recordset .•. FlexGrid: AutoSize columns .•. DB Reserved Words checker .
    Reply With Quote Reply With Quote
  6. Jan 24th, 2004, 02:52 PM #5
    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
    You can only "Make project" in VBA if you have MS Office
    Developer version installed. I had it installed back when I was
    using Office 2000, but since I have upgraded to 2003, I don't
    want to chance any incompatibilities between 2000 and 2003 to
    try installing it again. I don't remember if the option was to
    compile an .exe or a .dll. I didn't use it that much to be honest. I
    don't know if there will be a developer version for 2003?
    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