Thank you for your reply!

Trying to adapt it to my own needs, but struggling quite a bit!

Anyone suggest where i should put in to run my macro?

Some of the macro does rely on knowing what the open file is called.
(I've included the macro so you can see)

Thank you in advance

+-------------------------------------------------------------------
|Filename: macro.txt
|Download: http://www.excelforum.com/attachment.php?postid=4739
+-------------------------------------------------------------------

--
druce
-----------------------------------------------------------------------
drucey's Profile: http://www.excelforum.com/member.php...fo&userid=3255
View this thread: http://www.excelforum.com/showthread.php?threadid=54019