Well it wasn't necessarily public Sandy, but just declared, and at module
level (at least).

I couldn't see in the code where the open routine was called. One got the
filename, one opened it, one got the file, but which calls which, and how.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"SandyUK" wrote in
message ...

Thanks for the reply Bob

If I am understanding you correctly you are asking if i have declared
the variable as Public?

If so yes i have if not could you give me a little more detail?

Thanks

Adrian


--
SandyUK
------------------------------------------------------------------------
SandyUK's Profile:
http://www.excelforum.com/member.php...o&userid=17487
View this thread: http://www.excelforum.com/showthread...hreadid=547362