Thanks for handling this, Dave.

Max, if you want to be able to save "potentially dangerous attachments" go
to Tools, Options, Security and uncheck "Do not allow attachments....".

--
Jim Rech
Excel MVP
"Max" wrote in message
...
| attached a VBS script that I wrote to do that.
|
| Was unable to save it, Jim ..
| Could you paste it in the message itself ?
| Thanks
| --
| Rgds
| Max
| xl 97
| ---
| GMT+8, 1° 22' N 103° 45' E
| xdemechanik <atyahoo<dotcom
| ----
| "Jim Rech" wrote in message
| ...
| I don't believe Chip's routines is designed to handle files beyond 64K
| rows.
| Another approach is to pre-parse the file into several 64k row files.
| Copy it to your desktop and
| double-click it to run it.
|
| --
| Jim Rech
| Excel MVP
| "Roy Lynn" <Roy wrote in message
| ...
| | In Excel: If I know a file has 147,000 records, but Excel will only
load
| | 65,000, how do I get to the rest of the file?
|
|