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]
How can you merge and combine imported and converted .pdf to Excel 2007pages? [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]
Cleaning up imported data in excel using VBA. [more inside]
Automate Excel Filter.....
I am getting via email a CSV file daily that I would like to automate into excel.
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]
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]