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.

Post your code...
--
HTH...

Jim Thomlinson


"David P." wrote:

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.

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.

Now I'm really going to confuse you. I'm assuming the macro stops running at
Workbooks.Open Filename:="C:\Windows Template.xls" .

Sheets("P").Select
Range("I13").Select
Workbooks.Open Filename:="C:\Windows Template.xls"
Sheets("2").Select
Selection.Copy
ActiveWindow.WindowState = xlMinimized
ActiveWindow.WindowState = xlMaximized
ActiveSheet.Paste
ActiveWindow.WindowState = xlMinimized
Windows("Windows Template.xls").Activate
ActiveWindow.Close

--
David P.


"Jim Thomlinson" wrote:

Post your code...
--
HTH...

Jim Thomlinson


"David P." wrote:

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.

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.

Remove the shift key from the shortcut combination.

Holding down the shiftkey while you're opening a file tells excel not to run the
workbook_open event or the auto_open procedure. And it confuses excel so that
it never goes back to finish your code.

David P. wrote:

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.



--

Dave Peterson

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.
|
|

That's the problem. Thank you Dave & both Jims.
--
David P.


"Dave Peterson" wrote:

Remove the shift key from the shortcut combination.

Holding down the shiftkey while you're opening a file tells excel not to run the
workbook_open event or the auto_open procedure. And it confuses excel so that
it never goes back to finish your code.

David P. wrote:

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.



--

Dave Peterson