| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| opening excel files from access 2003, win xp, office 2003 | Excel Discussion (Misc queries) | |||
| cannot open any excel 2003 files with newly installed 2007 beta | Setting up and Configuration of Excel | |||
| Installed Excel Viewer 2003 but it wont download email data | Excel Discussion (Misc queries) | |||
| sku112.cab error message French office 2003 installed on german p | Excel Discussion (Misc queries) | |||
| Excel 2003 - long closing time when have many add-ins installed | Excel Discussion (Misc queries) | |||
Linear Mode
