And if you do use a shortcut key, make sure you don't include the shift key.

Holding the shift key while opening a file stops the open code from running.
And it seems to confuse excel into stopping any currently running code.


Bill in Inverness wrote:

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

--

Dave Peterson