Hello,
I'm not quite sure how your function would know what the range in
question is, at a glance. And with the way you've tabbed the code, or
lack thereof, that glance was trying...
You might be better off trying to use a single in-line procedure, e.g.,
http://www.danielklann.com/excel/sen...s_the_body.htm
The one thing I might add, would be to delete the temp. file once
you're done with it. You might use the Kill statement for this, but
I've had mixed results with this in the past..
I prefer to use the DeleteFile API function, never had a problem with
it. See the following:
http://www.mentalis.org/apilist/DeleteFile.shtml
Regards,
Nate Oliver