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
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
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Thanks MarvinP. I read the MS article, though I don't fully understand all the technical parts. I tried your suggestion and it's definitely going to save me from a lot of frustraion. But I am now wondering why this would suddenly begin happening to my code? I have been writing VBA for years and don't remember having this issue. Does it have anything to do with Windows 7. I don't recall if this started happening immediately after I got a new work laptop with Windows 7 back in November but I don't have the problem on my WinXP computer at home.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks