Hi. Im quite new to vba excel. Is there a way for me to prevent duplicate from being imported using any code or method. Below is the code that i will be using.
ChDir "Open from directory
sales = Application.GetOpenFilename("Text Files (*.txt), *.txt")
Workbooks.OpenText...