About a dozen people have tried to solve this. All failed. Exporting from Excel to .csv causes cells to show #NAME? instead of the actual value. [more inside]
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]
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]
Automate Excel Filter.....
I am getting via email a CSV file daily that I would like to automate into excel.
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?