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.
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.