I have a client that creates Excel reports by using links to a large master
spreadsheet. The reports are constantly changing and needless to say the
process of checking to be sure that the links are referencing the right cells
in the master sheet is a painful task.

I am looking for a way to list the external references in worksheet formulas
to a text file that I can import into Access. I can then match these
references against a table of cell references in the master table.

I could use some help with this - my VBA experience is primarily in Access.
Is there an easier way to do the same thing?

Thanks in advance for your help.

Scott


--
Scott S