I think the best solution is to find out why the other Macros didn't
work. I suspect that the answer if simple why the other methods didn't
work. I thinnk ther is a reference to a library that you need to add
into your VBA. VBA has a menu Tools - Reference and when you use some
application software you need to select some of the references in the
list. Without seeing the macro You are using I can't tell which library
you need to add. Yo need to either go back to the website you got the
code from and read the webpage carefully and look for "REFERENCE". if a
reference is missing, VBA will indicate this with an error message and
highlight the line of code in yellow. If yo post the highlighted line
and the exact error message we can help.


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=189275

http://www.thecodecage.com/forumz/chat.php