Hi
Hope all are doing good.
I have few questiong and want the solution for it.

I have a software which i buy it and that software collected the data like driver licence data when swiped and save that data to log which is in csv format. so everytime license is swiped the track data of licence stripe is saved to csv. data is general like first name last name,DOB etc.

Now I want a excel sheet, which i will keep it open (in use) , so when the customer swipe license the csv gets the data and then the excel gets data from the csv, I dont want to close and open the excel everytime to update the data on excel,

Do anyone know how i do that, Please remember I am new to excel macro and all, so i would appreciate if someone help me with the code or procedure.

the reason i want to keep the excel in open state is bcoz the counter person can see data on screen when card is swiped. and then i will put formula in excel when it gets data, like to calculate the number of visits of customer, if he/she is member.

Thanks
Piyush