| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to check if an excel sheet has external references.
Hi everybody, i want to know how to do this. Suppose there is a work sheet by name WrkSheet1 in WorkBook1 and there is another work sheet by name WrkSheet4 in WorkBook2. WrkSheet1 is linked to WrkSheet4( WrkSheet4 uses data from WrkSheet1 as input). How do i find out if WrkSheet1 has any dependencies or external references. I want to do this *Programmatically using VB*. I apologise if this has already been discussed. If it has already been discussed plz let me know as to where i can find it. With Regards, Daffo. -- Daffo ------------------------------------------------------------------------ Daffo's Profile: http://www.excelforum.com/member.php...o&userid=37472 View this thread: http://www.excelforum.com/showthread...hreadid=571337 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| Combining data from cells from several excel sheets to a new sheet | Excel Discussion (Misc queries) | |||
| Getting Excel Data from One Sheet to Another.... | Excel Discussion (Misc queries) | |||
| External data references in EXCEL 2002 | Excel Discussion (Misc queries) | |||
| How do you locate External References in an Excel Workbook | Excel Discussion (Misc queries) | |||
Threaded Mode
