Excel XP & Win XP
I took a macro to loop through all the files in a folder from Debra's site:
http://www.contextures.com/xlfaqMac.html#LoopBooks

I tested it without any changes and it worked fine.

I assigned a key combination, Ctrl-Shift-P, and then Ctrl-Shift-B, in turn,
to the macro. When I ran the macro from the key combination, the macro ran
but would not proceed beyond opening the first file. No error messages.
Nothing.

What is happening?

Thanks for your time. Otto

Try removing the shift key from the shortcut.

If you hold the shift down while opening a workbook, the auto_open and
workbook_open procedures won't run. When the shift key is part of the shortcut
key combination, it can confuse excel enough to stop the macro that's running.

Otto Moehrbach wrote:

Excel XP & Win XP
I took a macro to loop through all the files in a folder from Debra's site:
http://www.contextures.com/xlfaqMac.html#LoopBooks

I tested it without any changes and it worked fine.

I assigned a key combination, Ctrl-Shift-P, and then Ctrl-Shift-B, in turn,
to the macro. When I ran the macro from the key combination, the macro ran
but would not proceed beyond opening the first file. No error messages.
Nothing.

What is happening?

Thanks for your time. Otto

--

Dave Peterson

Thanks Dave. That sounds like the cause. I'll try it in the morning. Otto
"Dave Peterson" wrote in message
...
Try removing the shift key from the shortcut.

If you hold the shift down while opening a workbook, the auto_open and
workbook_open procedures won't run. When the shift key is part of the
shortcut
key combination, it can confuse excel enough to stop the macro that's
running.

Otto Moehrbach wrote:

Excel XP & Win XP
I took a macro to loop through all the files in a folder from Debra's
site:
http://www.contextures.com/xlfaqMac.html#LoopBooks

I tested it without any changes and it worked fine.

I assigned a key combination, Ctrl-Shift-P, and then Ctrl-Shift-B, in
turn,
to the macro. When I ran the macro from the key combination, the macro
ran
but would not proceed beyond opening the first file. No error messages.
Nothing.

What is happening?

Thanks for your time. Otto

--

Dave Peterson

I couldn't wait till morning. It works just like you said. Thanks again.
Otto
"Dave Peterson" wrote in message
...
Try removing the shift key from the shortcut.

If you hold the shift down while opening a workbook, the auto_open and
workbook_open procedures won't run. When the shift key is part of the
shortcut
key combination, it can confuse excel enough to stop the macro that's
running.

Otto Moehrbach wrote:

Excel XP & Win XP
I took a macro to loop through all the files in a folder from Debra's
site:
http://www.contextures.com/xlfaqMac.html#LoopBooks

I tested it without any changes and it worked fine.

I assigned a key combination, Ctrl-Shift-P, and then Ctrl-Shift-B, in
turn,
to the macro. When I ran the macro from the key combination, the macro
ran
but would not proceed beyond opening the first file. No error messages.
Nothing.

What is happening?

Thanks for your time. Otto

--

Dave Peterson

Homer Simpson yelling at the microwave: Cook faster!!!!!

Glad you got it working.

Otto Moehrbach wrote:

I couldn't wait till morning. It works just like you said. Thanks again.
Otto
"Dave Peterson" wrote in message
...
Try removing the shift key from the shortcut.

If you hold the shift down while opening a workbook, the auto_open and
workbook_open procedures won't run. When the shift key is part of the
shortcut
key combination, it can confuse excel enough to stop the macro that's
running.

Otto Moehrbach wrote:

Excel XP & Win XP
I took a macro to loop through all the files in a folder from Debra's
site:
http://www.contextures.com/xlfaqMac.html#LoopBooks

I tested it without any changes and it worked fine.

I assigned a key combination, Ctrl-Shift-P, and then Ctrl-Shift-B, in
turn,
to the macro. When I ran the macro from the key combination, the macro
ran
but would not proceed beyond opening the first file. No error messages.
Nothing.

What is happening?

Thanks for your time. Otto

--

Dave Peterson

--

Dave Peterson