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

Cleaning up imported data in excel using VBA. [more inside]
posted by corpse on Dec 21, 2007 - 1 answer

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

Help me get a professional massage! What is a "named range" in Excel and how do I create one? I cannot import an .xls file into her outlook contact folder until I address this issue. [more inside]
posted by sourwookie on Jul 5, 2005 - 6 answers

I have an Excel document listing dates times and other information. I'd like to import this "calendar" to iCal but cannot figure out to get the information imported properly. I found this tool, but couldn't get it to work. I also found this application, iCal Maker but it doesn't seem to work either. Anyone have an idea on how to import a bunch of events listed in an Excel document to iCal? [More Inside] [more inside]
posted by pwb503 on Dec 19, 2004 - 0 answers