Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook reference
I have a cell in a workbook that has the path of another workbook in
it. i can succesfully use the path to Open the workbook as such, "Workbooks.Open Filename:=Range("M1").Value. This works great. Its actuall the full path with directories. I then have another cell with just the name of the book to use for referencing it once it is already open. I just want to activate it using a code like "Windows("N1").Activate, so i can jump to it. This doesn't work and im not sure how to do it. I have also tried calling the path a string to no avail. Any help is great. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reference workbook name | Excel Worksheet Functions | |||
Reference different workbook | Excel Programming | |||
How To Reference The Previous Or Next Workbook s | Excel Programming | |||
Reference code in another workbook from a calling workbook | Excel Programming | |||
cell reference in another workbook | Excel Programming |