When stepping through code using F8, macro automatically runs at Workbooks.Open line

Hi exelji and welcome to the forum.

Try putting a DoEvents before and after the Workbooks.Open line in your code. See if that fixes the problem.
http://support.microsoft.com/kb/118468