| 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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Open a Workbook using VB
you didn't supply a lot of description of what you wanted.
Folder = "c:\temp\" MyDate = format(now(),"MM_DD_YYYY") FName = Folder & MyDate set bk = workbooks.open(filename:=FName) "cellist" wrote: 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Open a Workbook using VB
Joel,
Thanks for the info. You've answered my question, even though... you didn't supply a lot of description of what you wanted. That's true, I didn't supply much. My question was "in general", rather than one of "how do I determine the file/path name based on the current date?". I know how to do that, but did not know -- until you described how -- to use that pathname, or whether I even could use it. Now I know! Phil "Joel" wrote: you didn't supply a lot of description of what you wanted. Folder = "c:\temp\" MyDate = format(now(),"MM_DD_YYYY") FName = Folder & MyDate set bk = workbooks.open(filename:=FName) "cellist" wrote: 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 |
| Reply |
| 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 | |||
Hybrid Mode
