xml version of Excel -- <SupBook> tag.

BDBatBear

Board Regular
Joined
May 4, 2005
Messages
56
I have an external link in my workbook that I am trying to locate.

I saved my file as an xml file and did a search for "C:\". I did find the link in the xml file (see below). It is within a <SupBook> tag and before a list of sheet names. Does anyone know what this means regarding where this link is located?

<ExcelWorkbook xmlns="urn:schemas-microsoft-com:eek:ffice:excel">
<SupBook>
<Path>C:\Temp\Temporary Internet Files\OLK10F\BAL DEV 051110a.xls</Path>
<SheetName>SearchResults</SheetName>
<SheetName>ASData</SheetName>
<SheetName>Cover</SheetName>

Thanks,

- Bruce
 

Some videos you may like

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

Watch MrExcel Video

Forum statistics

Threads
1,118,917
Messages
5,575,027
Members
412,635
Latest member
Arren
Top