Hi Steve,

I have a similar problem in that a VBA macro that used to work now quits executing after it opens a file. I have no suggestions, but it sounds similar to your problem. Perhaps the gurus will have a suggestion.

I reduced my macro to the following and it always opens the file but stops executing before the move to the last entry in column B.

ChDir "C:\Documents and Settings\bill\My Documents\NewCode\TestFileOpen"
Workbooks.Open Filename:="TestFile.xls"
Range("B2").End(xlDown).Select
...

Let's hope someone knows what our problem is.