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
Bookmarks