I am trying to import a couple hundred .csv files into one excel 2000 worksheet. I’d like to be able to do it automatically, but know virtually nothing about this. Basically each file has a different name, ex a-12.csv, b-13.csv. They are all in the same directory. What I’d like to do is put the file name (minus .csv if possible, but not necessary) in the B column for each line within the file that I’m importing. That way I know which data came from which file. The data starts in the c column. The data is comma deliminated, and when I import manually, all I have to do is click on the cell I want the data to start in, look for a .csv file, open it, set comma deliters and import. Is there anyway to do this? I’m pretty clueless so even if there isn’t if there are any suggestions on just making the process easier I’d appreciate it!