What Dave said holds even if the workbook you're opening doesn't have any
macros. It kills the calling macro too.

--
Jim
"David P." wrote in message
...
| Yes, by keyboard shortcut.
| --
| David P.
|
|
| "Jim Rech" wrote:
|
| Macro to open Workbook B
|
| How do you execute this macro? Keyboard shortcut?
|
| --
| Jim
| "David P." wrote in message
| ...
| |I have a macro that opens another workbook but it appears that the
macro
| | fails to finish because it's almost like it's not waiting for it to
load.
| | Essentially this is what I'm doing:
| |
| | Workbook A is open
| | Macro to open Workbook B (this takes a second to load therefore
cancelling
| | the rest of the macro)
| | Copy selected text from B
| | Close Workbook B
| | Paste info on Workbook A
| |
| | Your help appreciated.
| | --
| | David P.
|
|