+ Reply to Thread
Results 1 to 5 of 5

Run VBA outside of Office applications

  1. #1
    Registered User
    Join Date
    10-17-2013
    Location
    Hyderabad, AP, India
    MS-Off Ver
    Office 2010
    Posts
    6

    Run VBA outside of Office applications

    Hi all,

    I am not sure if this the right group for my research question. If not I'd appreciate if the some one can guide me to the right forum.

    I am extracting the VBA code from the VB Project in an Excel file. Now I need to be able to run the VBA macros outside of Excel without using Microsoft Office's VBA builder.

    Are there any solutions to implement this or has any one tried to run VBA code outside of Excel without using Office components?

    I'd really appreciate any help or direction.

    Thanks
    - Jaideep

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,411

    Re: Run VBA outside of Office applications

    Depends what the code does. You might be able to incorporate it into a free standing VB Script.

    This link gives a fairly comprehensive write up on VBA:

    http://en.wikipedia.org/wiki/Visual_...r_Applications


    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Expert
    Join Date
    04-22-2013
    Location
    .
    MS-Off Ver
    .
    Posts
    4,418

    Re: Run VBA outside of Office applications

    You can't compile vba outside of microsoft excel (as far as I know). However, you can compile vb or vbscript outside of microsoft excel, for example, as a .exe - depends on what your code looks like as to how easy it is to transfer from vba to vb/vbs

  4. #4
    Registered User
    Join Date
    10-17-2013
    Location
    Hyderabad, AP, India
    MS-Off Ver
    Office 2010
    Posts
    6

    Re: Run VBA outside of Office applications

    Has anyone tried to convert VBA code to some other language like javascript or VBScript and use it outside of Office applications. Assuming the VBA code has no reference to any of the Office components and simply has a Hello World Message Box.

  5. #5
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,411

    Re: Run VBA outside of Office applications

    Yes, I think that has been done.

    http://c2.com/cgi/wiki?HelloWorldInM...mmingLanguages


    Regards, TMS

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 17
    Last Post: 11-15-2011, 07:01 AM
  2. Hyperlinks Between Office Applications?
    By DCSwearingen in forum Excel General
    Replies: 3
    Last Post: 03-30-2007, 09:34 AM
  3. Problems with Office Applications
    By Todd Beauchemin in forum Excel General
    Replies: 4
    Last Post: 07-06-2005, 02:05 PM
  4. Office 2003 documents readable by Office 2002 applications?
    By Captain Infinity in forum Excel General
    Replies: 2
    Last Post: 05-10-2005, 06:06 PM
  5. Cannot create new? In all office 2003 applications
    By Vakul in forum Excel General
    Replies: 2
    Last Post: 04-25-2005, 02:06 AM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1