On 17/02/2017 12:35, Paul Newton wrote:
Richard
Unfortunately, you are copying the worksheet to a new worksheet in the same workbook. I want to copy the active worksheet to a new worksheet in a different workbook (which already exists), _without_ opening the target workbook ... still don't have a solution for that
Without opening the target workbook? Can't see how you would achieve that. When you open the workbook and add a sheet you then need excel to save it for you and to update the internal structure of the workbook.
Peter
This communication is intended for the person or organisation to whom it is addressed. The contents are confidential and may be protected in law. Unauthorised use, copying or disclosure of any of it may be unlawful. If you have received this message in error, please notify us immediately by telephone or email.
www.whisperingsmith.com
Whispering Smith Ltd Head Office:61 Great Ducie Street, Manchester M3 1RR. Tel:0161 831 3700 Fax:0161 831 3715
London Office:17-19 Foley Street, London W1W 6DW Tel:0207 299 7960