|re: "wants to update the column of excel file to 1"|
What do you mean by "update the column"?
A column is series of cells, such as A1, A2, A3, etc. all the way down to the bottom of the spreadsheet. I don't know what you mean by "update the column to 1". Do you want every cell in the column to be equal to 1?
re: ...as soon as the system gets locked or unlocked...
What do you mean by locked or unlocked?
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.