What files required to run vba in excel?

jgoulart · Mar 25th, 2002, 12:32 PM

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

Jack in the UK · Mar 25th, 2002, 12:47 PM

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

Tom Schreiner · Mar 25th, 2002, 02:08 PM

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 ]

Mar 25th, 2002, 12:47 PM	#2
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	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"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 25th, 2002, 12:32 PM	#1
jgoulart Board Regular Join Date: Feb 2002 Location: John G Posts: 62	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

Mar 25th, 2002, 02:08 PM	#3
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	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 ]