Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how does one follow a cell link to another workbook file
Hello Excellers,
I have a worksheet cell that contains a formula that refers to a cell in another workbook file. I have a VBA macro that needs to follow that reference. That is, open the referenced file, and go to the sheet of the referenced cell (so as to get other things from the same sheet). In the past I've simply extracted the file name from the cell formula using string functions. But that only works with straightforward cell links which simply refers to a cell in the other file. That is, the cell formula only contains one file name in it somewhere. Now I'd like to handle a situation where the cell formula is more complicated. In this case the formula uses the Choose worksheet function to pick a link to another file. This means the formula contains more than a just one file name. So my method of using string functions to extract the file name doesn't cut it anymore. Is there any way to determine the file name of the cell being referenced by the more complicated cell formula? Thanks, Brian Murphy Austin, TX |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HOW DO I LINK PAGES ON EXCEL TO FOLLOW SAME LINKED FORMULA? | Excel Worksheet Functions | |||
follow link | New Users to Excel | |||
How do I link data from another workbook using a different file na | Excel Discussion (Misc queries) | |||
How can I follow a Hyper-link by just pressing "Enter"? | Excel Discussion (Misc queries) | |||
Follow hyper-link by pressing "Enter" | Excel Discussion (Misc queries) |