Must Access be installed to use VBA in Excel 2003?

[Melody]

I have a project that gets a "can't find project or library" error when
running on a computer that does not have Access installed. Runs fine on a
computer with Access. Tools/References is grayed out. Can VBA code be made
to run without having Access installed?

 

[Gary''s Student]

Yes. Excel VBA can run without other Offfice products being installed.

 

[Gord Dibben]

Depends.

One example.............

If your project involves a Calendar you will be missing the mscal.ocx if Access
is not installed.

You can download a copy from here.

http://www.fontstuff.com/vba/vbatut07.htm


Gord Dibben MS Excel MVP

 

[Melody]

How? What exactly needs to be installed or how does Excel need to be
configured. What is wrong now that is causing this error?

 

[Jon Peltier]

Reread Gord's post. Excel VBA doesn't need Access to be installed in order
to run. However, if you are relying on the MSCAL calendar ActiveX control,
which is not strictly part of VBA, you will have issues, because it isn't
installed with Office unless Access is installed.

- Jon

 

[Gord Dibben]

Did you see my reply Melody?


Gord Dibben MS Excel MVP

 

[Melody]

I did but it is still not working. I am not using a calendar. I keep
reading that this should run without Access but nobody says how. Are there
options when installing Excel itself that need to be included, (or not
excluded)? It is being installed from the MS small business version as a
stand-alone component.

 

[Jon Peltier]

It should just run, no magic, no secrets. Select the project in the VB
Editor, then go to the Tools menu and select References. Is anything listed
that begins with "MISSING:"? Perhaps even the Access library? If so, uncheck
it, and try again.

- Jon