I am trying to import a CSV file into a work sheet. The file has varying length as it is created from a worksheet. The name of the file is Spotters.csv and the sheet in the workbook is named Spotters. I have searched the web for a solution and the only answer I can find loads the first line of the file an infinite number of times into the sheet. Currently the csv file has 256 lines in it but this number constantly changes as new entries are made.
Thanking you in advance for your answers.
Thanking you in advance for your answers.