Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm writing a function to parse out the path, workbook name, worksheet, and
range of all the XL Worksheet links (no other kind of links). Does anyone know if Worksheet links ALWAYS follow the same format? For instance, if I have a formula that refers to the cell A1 in another workbook, the formula will contain the following text: 'C:\Folder\Path\[workbook_nm.xls]worksheet nm'!A1 I'd like my function to return the following: - C:\Folder\Path\workbook_nm.xls - workbook_nm.xls - worksheet nm - A1 I know _HOW_ to do that, but I want to make sure it will work across the board, or if there are any exceptions when a Worksheet link will not follow the format above. TIA. -- Hmm...they have the Internet on COMPUTERS now! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
excel outlines structure | Excel Discussion (Misc queries) | |||
can excel links be somehow relative to folder structure? | Excel Discussion (Misc queries) | |||
Not getting the object structure of VBA Excel | Excel Programming | |||
Analyze Excel files structure | Excel Programming | |||
Analyze Excel files structure | Excel Programming |