Must Access be installed to use VBA in Excel 2003?

M

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?
 
M

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?
 
J

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
 
M

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.
 
J

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
 
Top