PDA

View Full Version : how to set import defaults?



grademonkeyj
09-13-2010, 08:37 AM
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
09-13-2010, 09:51 AM
Why not record your actions on the macro recorder and then adapt the code?

grademonkeyj
09-13-2010, 10:42 AM
I've tried this, but the macro recorder does not record anything when I change settings in the import dialog.