Power Query Course in Spanish
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: What files required to run vba in excel?

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Location
    John G
    Posts
    62
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I want to distribute an excel vba program and I want to make sure that there is nothing special that users have to set up on thier system in order to run it. I guess my initial assumption is as long as the user has a working version of (I'm writing in excel97 and testing in 2000 as well) excel97 or greater they shouldn't have to do anything special other than choose "enable macros" when the file is opened. Is this a correct assumption or is there a component that isn't loaded on a typical excel installation that will prevent VBA from running? Is there a setting that the user can choose that will disable all macros that I need to make them aware of to change? Thanks for the help.

    John

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I want to distribute an excel vba program and I want to make sure that there is nothing special that users have to set up on thier system in order to run it.

    No excel has VBA built in like it or not.

    I guess my initial assumption is as long as the user has a working version of (I'm writing in excel97 and testing in 2000 as well)

    Yes if users have E97+ it will work OK

    excel97 or greater they shouldn't have to do anything special other than choose "enable macros" when the file is opened.

    Correct they canchoose unless options set to low, not very recomended thou:

    Is this a correct assumption or is there a component that isn't loaded on a typical excel installation that will prevent VBA from running?

    No like i say i have never hit agros in this default ie typical will load VBA and of cause the VBE (Editor)but poss agros on OEM some help file goes missing ,,,, in VBA

    Is there a setting that the user can choose that will disable all macros that I need to make them aware of to change?

    No only if they set macro warnings to low, but not advised a pain but worth it is a second to check the file is known prior to opening.

    Thanks for the help.

    Hope taht ok, post more if needs be,,,,
    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    When you are in the VBA development environment, click on Tools, References.
    Those are the files on which your project is dependant. Most are standard, but I have had problems with references on different machines even though they were running the same version as I.
    Not a huge deal to fix references.
    Have Fun!
    Tom

    P.S. The checked files are the ones you need.

    [ This Message was edited by: TsTom on 2002-03-25 13:10 ]

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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