| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Referring to a variable file name
With Bob Phillips help I can create a variable filename. The filename is
contained in a cell called Filename_Finance. When I try to activate the window I can't make it work. I've tried the following code: Windows.Range("Filename_Finance").Activate Windows(Range("Filename_Finance")).Activate Workbooks.Range("Filename_Finance").Activate Workbooks(Range("Filename_Finance")).Activate but none of these work. When using the workbooks option I was mindful to add the .xls. Can someone help please? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| variable file names | Excel Discussion (Misc queries) | |||
| referring to a cell containing a file name | Excel Discussion (Misc queries) | |||
| Variable File Name | Excel Worksheet Functions | |||
| Inport from a variable file name | Excel Discussion (Misc queries) | |||
| open file (as variable) from macro | Excel Discussion (Misc queries) | |||
Threaded Mode
