Here is another source of information:
http://support.microsoft.com/support...eio/fileio.asp
File Access with Visual Basic® for Applications


--
Regards,
Tom Ogilvy

twaccess wrote in message
...
Phobos

I enjoyed this very brief thread... This is a subject close to my heart
as I have spent many hours cutting, parsing and pasting data from text
files to Excel and back again.... This opens a door for me for doing it
by vba.... along with membership of this forum too.

I ran the code and its cute... (Sorry, I'm easily impressed !!)

I wonder if you would mind putting some explanatory notes against
certain elements of the code such as "dim dblZ" "#fn" etc to help me
understand better how this code works.

Thanks


tdub



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/