Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Forms and Modules
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Forms and Modules
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Forms and Modules
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 . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Forms and Modules
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 . |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Forms and Modules
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VB Modules | Excel Discussion (Misc queries) | |||
Modules and Forms II | Excel Programming | |||
Modules and Forms | Excel Programming | |||
Need help on How to programatically Import VBA Project Excel Objects, Forms, Modules | Excel Programming | |||
Class Modules vs Modules | Excel Programming |