Need VBA code and can't find one that works

[KA3PMW]

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.

 

[alansidman]

Load it to the PQ editor and then Close and Load to the specific sheet and cell location you wish and name that sheet as needed. Suggest you post your sample csv to a third part location such as box.net or dropbox.com and allow us to show you step by step. Otherwise, wait patiently for someone else to help you with a VBA solution.