Ok I have found the problem related to my second problem it seems tha
the .Filename is unable to accept filesearch wildcard. (*) Can anyon
tell me why

--
stevetan201
-----------------------------------------------------------------------
stevetan2010's Profile: http://www.excelforum.com/member.php...fo&userid=1624
View this thread: http://www.excelforum.com/showthread.php?threadid=27647