I tested the code before I gave it to you so I'm not sure what the problem
is. Sorry.

--
Jim Rech
Excel MVP
"gls858" wrote in message
...
| Jim Rech wrote:
| Put our macro in BackOrders.xls and run it after opening this workbook.
The
| macros handles steps 2, 3 and 4. Also it closes the text file so maybe
| that's why you think "nothing is happening". The data should end up in
the
| cell in Backorders.xls that was selected when you ran the macro.
|
|
| Jim,
| After a some experimentation it seems that that data is not
| being pasted to the BackOrders.xls. By commenting out just
| this line, ActiveWorkbook.Close False, I see the data has been
| imported, but not pasted to BackOrder.xls.
|
| Could the problem be that the imported file is not
| actually an .xls file until it's saved?
|
| gls858