I have created a file that allows me to import file. The main problem is the cleardata subroutine. The purpose of it is to check whether the sheet named "Data" have any data. If yes, they will delete the existing data. If no, it will import the file there. However, i have trouble running the code as i faced errors in the import(path, filename) area.
Any help i can get is greatly appreciated!