Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 323
  • Last Modified:

How to determine if a Excel Spreadsheet references external datasources.

Heyas,

Can anyone point me in the right direction as to how in VBA terms I could determine if a cell in an Excel spreadsheet was getting it's data from an external datasource Website, DB other workbook etc.  Also if it's possible is there a way to determining what the external datasource was, this may be stretching the limits of vba I think though.
Any help would be much apperciated.

Thank you.
0
Zack
Asked:
Zack
  • 2
1 Solution
 
[ fanpages ]IT Services ConsultantCommented:
Hi,

With a Visual Basic for Applications routine you could iterate through the list of LinkSources for the respective worksheet where the cell resides looking for matches for the cell address.

You could also use the Visual Basic for Applications Find syntax to search for cells with a Formula containing either a "[" or "]" (left & right brace).

Some further discussion here:

"How to find and list all links (external references) in Excel?"
[ http://www.extendoffice.com/documents/excel/953-excel-list-all-links.html ]

BFN,

fp.
0
 
ZackGeneral IT Goto GuyAuthor Commented:
Cheers for the info.
0
 
[ fanpages ]IT Services ConsultantCommented:
You're very welcome.

Thanks for closing the question.
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now