<img src=/S/help.gif border=0 alt=help width=23 height=15> I'm not even sure if it is possible to automate this, but it would save me a LOT of time if it is. I have a bunch (about 700) of comma delimited text files that I would like to import into one spreadsheet. I have two problems with this.
1. I want to automate the whole Text Import Wizard so I don't have to go through the the wizard for each one
2. I don't know how to "append" one spreadsheet to the end of another without copying and pasting the cells over (very tedious)
If anyone has any ideas as to how to make this process a little easier, I'd love some suggestions.