Hi Nigel,

When I say halts, Excel is active and the worksheet has loaded. However, VBA is no longer runing.

I solved my problem by rewriting the code completely and it runs per all the Microsoft documentation. However, I want o understand theproblem so I know shat to do when it occurs again. When I figure this out, where should I send my diagnosis?

Thanks,Bill

----- Nigel wrote: -----

Bill,
It seems the selection or activation of the workbook and worksheet might be
required?

When you say it quits,do you mean the procedure or Excel?

Cheers
Nigel

"Bill in Inverness" wrote in message
...
Hi all,
I have a number of files to process and I don't want to add the same
duplicative VBA code to each file. Putting the code into single workbook
with a loop to open and process the files sequentially seemed logical.
However, my code halts after opening the first file. Any idea what might
be wrong?
I reduced the code to bare bones (without the loop) and it still quits
after opening the first file. The start of the processing code is simple:
Workbooks.Open Filename:="C:\Tests\OpenTest.xls"
Range("B2").End(xlDown).Offset(1,0).Select
The computer a new Compaq running Excel XP SP2 with all available Office
updates applied and running under Windows XP Home Edition SP1 with all
Critical updates and all but a few of the Recommended updates installed.
Thanking you in advance, I look forward to enlightenment
Bill





----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeed.com The #1 Newsgroup Service in the World! 100,000 Newsgroups
---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =---