Hello,
Is it possible to copy existing worksheet from to another workbook but as another excel instance? I'm trying to do something like this:
It copy Sheet GTB to new Workbook but in the same excel instance and I would like that it automaticlly create new excel instance with workbook with copied sheet GTB. Is it possible?
Please Login or Register to view this content.
hi,
Welcome to the Forum
Unfortunately, AFAIK, it is not possible to copy a sheet to another instance, using just VBA code, but you may find something in Leith's posts in these threads
(I'm on a very slow connection so I haven't checked them)
Why does it need to be in a new instance of Excel?
A possible workaround would be to copy the sheet within the same instance, close & save the new file, and then reopen it in the new instance.
hth
Rob
Rob Brockett
Kiwi in the UK
Always learning & the best way to learn is to experience...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks