But I believe you can do it in an excel macro .. at least I've found sample code that does just that - looks like I WILL have to open the target workbook
-----Original Message----- From: ProfoxTech [mailto:[email protected]] On Behalf Of Peter Cushing Sent: 17 February 2017 12:40 To: [email protected] Subject: Re: Copy Excel worksheet to another workbook 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 [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
