I have another problem with the Workbooks.Open Filename procedure.

The script line below opens the comma delimited CSV file in a new workbook. That means if I execute the macro in one workbook the data will appear in a newly created workbook.

That's bad. I need the data in the workbook in which I execute the macro. Is there a way to modify the script below so that I can achieve that?

I tried ActiveWorkbook and ActiveWorksheet but both don't work.

Workbooks.Open FileName:=FileName2