Post the code  you are talking about so we can try to see what is going wrong.
Just copy the code from the VBA editor and paste it into an email.

You will probably need to let us see both the code that opens  the workbook  and
the workbook activate  code.