1 Attachment(s)
Check txt file 4 mealbreak n display in XL??
Im reading in a text file in Excel...There are data like this:
TT101,B01,MB1,0,1,rmk
TT101,C02,C12,5,6,
etc
etc
etc
in it..
The first param is an ID then,from blk, to blk, start time, end time, remarks..remarks is blank sometimes.. When reading the file, if it encounters "MB1" then my program should check which blk and in which period it falls.. (The first param is an ID then,from blk, to blk, start period, end period, remarks). Getting this info, it should go to the sheet(attchaced is the file) and check the periods against the blk (take a good look at it pls). If lets say it gets the data as above (TT101,B01,MB1,0,1,rmk) then it should highlight and print the word MB1 or MB2(I've shown it in the file at cell O3, pls download n see) Thanks alot for help guys..Pls help..
:rolleyes: