Is there a way I can get an open Workbook to utilize the
Forms and Modules from a closed Workbook?

Of, if that won't work, is there a way I can get a second
Workbook to automatically open as the 1st Workbook opens?

My problem is that I have a Workbook that is too large to
practically utilize across a network or to mail.
Therefore, I am looking for a way to store the forms and
modules some place else without losing the funcionality of
the program???

SDC

If you create a reference to the second workbook it will open when the first
workbook is opened. You can not close it until the first workbook is
closed.

--
Regards,
Tom Ogilvy

scrabtree23 wrote in message
...
Is there a way I can get an open Workbook to utilize the
Forms and Modules from a closed Workbook?

Of, if that won't work, is there a way I can get a second
Workbook to automatically open as the 1st Workbook opens?

My problem is that I have a Workbook that is too large to
practically utilize across a network or to mail.
Therefore, I am looking for a way to store the forms and
modules some place else without losing the funcionality of
the program???

SDC

Cannot access a closed workbook.

So ... in the Workbook_Open() subroutine you can put a Workbooks().Ope
line.

... or put the file in your XLSTART folder (etc) (just lik
Personal.xls)

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com

How do I create that reference?

-----Original Message-----
If you create a reference to the second workbook it will
open when the first
workbook is opened. You can not close it until the first
workbook is
closed.

--
Regards,
Tom Ogilvy

scrabtree23 wrote
in message
...
Is there a way I can get an open Workbook to utilize the
Forms and Modules from a closed Workbook?

Of, if that won't work, is there a way I can get a
second
Workbook to automatically open as the 1st Workbook
opens?

My problem is that I have a Workbook that is too large
to
practically utilize across a network or to mail.
Therefore, I am looking for a way to store the forms and
modules some place else without losing the funcionality
of
the program???

SDC


.

open the second workbook. go into the VBE and right click on the
Thisworkbook entry in the project explorer (treeview) window, selecting
properties. Change the name from the default VBAProject to something
unique.

Now make workbook1 the active project by clicking on it in the project
explorer. Go into tools = references in the menu and click on the box next
to the entry with the unique project name you assigned above.

Now Save both workbooks.

--
Regards,
Tom Ogilvy

scrabtree23 wrote in message
...
How do I create that reference?

-----Original Message-----
If you create a reference to the second workbook it will
open when the first
workbook is opened. You can not close it until the first
workbook is
closed.

--
Regards,
Tom Ogilvy

scrabtree23 wrote
in message
...
Is there a way I can get an open Workbook to utilize the
Forms and Modules from a closed Workbook?

Of, if that won't work, is there a way I can get a
second
Workbook to automatically open as the 1st Workbook
opens?

My problem is that I have a Workbook that is too large
to
practically utilize across a network or to mail.
Therefore, I am looking for a way to store the forms and
modules some place else without losing the funcionality
of
the program???

SDC


.