How do I copy an entire worksheet to another instance of excel?
"Jim Thomlinson" wrote in message
...
To the best of my knowledge you can't. That is why I never create
multiple instances of Excel. One instance is completely independant
of the other and the two can not interact.
Thanks for your quick reply.
If you avoid doing it that way, is there another route I could take?
The reason I was hoping to copy to another instance is that there are
a lot of settings tied down in the original application instance (cell
drag and drop / copy and paste - enough to render the application
fairly useless as an excel application but very safe for the data).
Of course, the best solution would be to move to a different tool
(Access probably), but that would incur a lot of time / effort that we
cannot really justify at this point.
Thanks again!
Alan.
|