how to set import defaults?

[grademonkeyj]

Hi Folks,

I'm using Excel 2007 to analyze data from a curriculum program - I've written a handful of macros that clean up the data and compute grades.

I'm trying to make the project a little more user-friendly and I'm using Excel's built-in import dialog to import .csv files into a worksheet. I would like to specify the import defaults in my code so the user doesn't have to do this each time - the file format is always .csv so I want the delimiter to be "comma" but I don't want to have to specify this every time I import. Is there a way to set this default?

Thanks, any input would be appreciated.

[Simon Lloyd]

Why not record your actions on the macro recorder and then adapt the code?

[grademonkeyj]

I've tried this, but the macro recorder does not record anything when I change settings in the import dialog.