Structure of Excel Links
 

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!

Structure of Excel Links
 

No other worksheet functions in those cells???

Sometimes the path uses the UNC style: \\server\sharename\path

And if that other workbook is open, the path isn't shown.



MDW wrote:

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!

--

Dave Peterson

Structure of Excel Links
 

Thanks.

--
Hmm...they have the Internet on COMPUTERS now!


"Dave Peterson" wrote:

No other worksheet functions in those cells???

Sometimes the path uses the UNC style: \\server\sharename\path

And if that other workbook is open, the path isn't shown.



MDW wrote:

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!

--

Dave Peterson