Must Access be installed to use VBA in Excel 2003?
 

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?

Must Access be installed to use VBA in Excel 2003?
 

Yes. Excel VBA can run without other Offfice products being installed.
--
Gary''s Student - gsnu200765


"Melody" wrote:

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?

Must Access be installed to use VBA in Excel 2003?
 

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

On Mon, 14 Jan 2008 12:53:00 -0800, Melody
wrote:

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?

Must Access be installed to use VBA in Excel 2003?
 

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

"Gary''s Student" wrote:

Yes. Excel VBA can run without other Offfice products being installed.
--
Gary''s Student - gsnu200765


"Melody" wrote:

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?

Must Access be installed to use VBA in Excel 2003?
 

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


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

"Gary''s Student" wrote:

Yes. Excel VBA can run without other Offfice products being installed.
--
Gary''s Student - gsnu200765


"Melody" wrote:

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?

Must Access be installed to use VBA in Excel 2003?
 

Did you see my reply Melody?


Gord Dibben MS Excel MVP

On Tue, 15 Jan 2008 05:56:03 -0800, Melody
wrote:

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

"Gary''s Student" wrote:

Yes. Excel VBA can run without other Offfice products being installed.
--
Gary''s Student - gsnu200765


"Melody" wrote:

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?

Must Access be installed to use VBA in Excel 2003?
 

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.

"Gord Dibben" wrote:

Did you see my reply Melody?


Gord Dibben MS Excel MVP

On Tue, 15 Jan 2008 05:56:03 -0800, Melody
wrote:

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

"Gary''s Student" wrote:

Yes. Excel VBA can run without other Offfice products being installed.
--
Gary''s Student - gsnu200765


"Melody" wrote:

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?

Must Access be installed to use VBA in Excel 2003?
 

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Melody" wrote in message
...
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.

"Gord Dibben" wrote:

Did you see my reply Melody?


Gord Dibben MS Excel MVP

On Tue, 15 Jan 2008 05:56:03 -0800, Melody

wrote:

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

"Gary''s Student" wrote:

Yes. Excel VBA can run without other Offfice products being
installed.
--
Gary''s Student - gsnu200765


"Melody" wrote:

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?