| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open a workbook using a stored name
I have several workbooks (call them WB1 and WB2) that moves data to a central
workbook (call it WBMain and its name never changes). Once WB1 or WB2 has passed their data it leaves WBMain activated. At the time WBMain was activated the name and path for WB1 or WB2 was stored on WBMain in named cells (WBName & WBPath). My problem, although it should not happen, if the user closes WB1 or WB2 while in WBMain then when required to go back to WB1 or WB2 it must do so using the name and path stored on WBMain. I can't seem to get it done. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hyperlink stored in an external workbook | Excel Discussion (Misc queries) | |||
| Open a specific workbook...find value from other open workbook and then insert cells values in cell next to it. | Excel Programming | |||
| using a workbook to open more workbooks with filenames stored in cells | Excel Programming | |||
| Locating the directory a workbook is stored in | Excel Programming | |||
| Refer to picture stored in workbook | Excel Programming | |||
Threaded Mode
