ExcelMacroFilter: Writing a macro that imports a series of .csv files into their own worksheets in the same workbook in Excel 2007 would save me ridiculous amounts of time. I have written a macro to import the files and rename the worksheet accordingly, but I'm new to VBA and can't for the life of me work out how to get Excel to automatically repeat the import from File_1.csv to File_x.csv. Help please? [more inside]
posted by cholly on Jul 30, 2009 - 4 answers

Excel is chapping my hide. I have a comma-delimited .csv which contains quote-demarcated text fields. The source of my never-ending joy is the recurrent use of inch-marks and commas within the textfields. Right this way... [more inside]
posted by mwhybark on Feb 25, 2009 - 18 answers

Automate Excel Filter..... I am getting via email a CSV file daily that I would like to automate into excel. [more inside]
posted by keep it tight on May 14, 2007 - 4 answers

I have several hundred contacts with all sorts of information in my old OS9 outlook, which I must keep using for awhile due to our antiquated network. However, I was able to export my contacts as a "csv" file which seems to be some sort of excel spreadsheet. How do I import it into my OSX address book?
posted by luriete on Oct 14, 2004 - 7 answers