Code to open a workbook , copy info and return it to another workbook using a cell v.

Use this statement before opening the workbook and set to True after closing.

Application.EnableEvents = False