Results 1 to 3 of 3

Update txt connection based on a cell value

Threaded View

Zaeguzah Update txt connection based... 03-16-2010, 05:35 AM
mdbct Re: Update txt connection... 03-16-2010, 11:27 AM
Zaeguzah Re: Update txt connection... 03-17-2010, 03:54 AM
  1. #1
    Forum Contributor
    Join Date
    07-16-2009
    Location
    NA
    MS-Off Ver
    MS Excel 2010
    Posts
    237

    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
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1