I am in need of verifying the linked excel tables (external Excel files) are proper. I am setting the connectionStrins in VBA and the customer can easily change those links. Therefore, I need to verify links are proper to proceed with automated analysis.

Is there a way to get a debug.print list of all externally linked file "Paths"?

Thanks