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

[england79m]

Please Login or Register  to view this content.

Hi this code works perfectly just need a tweek how can I get the workbook which is opened up not to run any macros, because the workbook has an on open and an on close macro.

[T-J]

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

Please Login or Register  to view this content.