I am trying to import a text file every five minutes to give the latest items scanned in at the factory. My code seems to work perfectly but I am concerned that I could be locking the source text file and causing other users not to be able to save data to it. I have pasted my code into the code window, can someone tell me if this reads the source data into memory and then closes it or does it leave the source file open (and hence locked) while I read it. Is there a better way to do this process than the one I am using.
Thanks in advance,
Open "p:\mypath" & Format(Date, "DDMMYYYY") + ".amp" For Input As #1