Hi leejac11

As Marc said you should post your problem in a thread of your own because "old threads" don't get as much attention as a "new thread" also it's against forum rules.

As my macro was written for "Excel 2007 - 2010" and you are running the "Mac 2011" version of office I really don't know what the problem could be.

My best advice is that you start by recording a macro when importing a csv file from the desktop folder to your workbook. You can then compare your macro with the one I wrote and see if you could modify a macro to suit your needs.

Alf