| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open a Workbook using VB
Running EXCEL 2003.
I have an application that the user launches by opening a saved workspace (.xlw). The saved workspace includes three related workbooks, all loaded from fixed locations. A fourth workbook is needed, but its location is based on the current date. I'd rather not rely on the user to figure out which instance of the workbook to open. Can I run VB code that will figure out the correct pathname and dynamically open the fourth workbook? TIA, Phil |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to: Open closed workbook/Search data tables/Return data to open workbook | Excel Discussion (Misc queries) | |||
| how do i open a data workbook when i open a timesheet 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 | |||
| excel 2003 saved file will not open without a blank workbook open | Excel Discussion (Misc queries) | |||
| How do you program so that Workbook B cannot be open unless Workbook A is open? Plus I need to validation | Excel Programming | |||
Threaded Mode
