We set up an import specification for seveal text files we want to import. We created a macro to automate the process and import several files one after the other. The macro worked. We then converted the macro to VB code. The code works, but only if we do a manual import of one of the text files first. We need the import to work in code without having to prime the pump. Any ideas will be appreciated. Thanks in Advance.