D
David P.
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.
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.