Update txt connection based on a cell value

Hi all,

I'm wondering if this could work through vba. I have a workbook of 58 sheets. All the sheets except the first two contain two connections to .txt files. The range is the same in all the sheets. First has the range of T:W and the second Y:AC.
Upon opening the workbook, I would like to update all links if a certain cell C3 contains "Da". If it contains anything else except "Da" then do not update the connections and delete the data in T:W and Y:AC but leave the connection intact.
I've attached an example of how the data looks.

Thanks for your time,
Alex

In the Workbook_Open() event use the following:

Please Login or Register  to view this content.

I've reattached your book with the code.

Works well be there are two problems:
1. it will need to run on all sheets except the first two
2. when it doesn't contain "da", the data that is included in the sheet (t:w and y:ac) should be deleted. If it could be done of course without breaking the connection itself.