Hi,

I would like to open a workbook in an existing Excel session with a
macro/ VBA instead of creating a new session.

Background:
I copy certain cells from workbook B to workbook A. This task is
initiated by a macro which is part of the open workbook A. The macro
opens workbook B, copies the cells (or the content of the cells) from
Workbook B to A and closes workbook B again. So far, so good. However,
some cells in the source workbook B cause a runtime error while
copying. The reason seems to be that those cells contain too many
characters; to be precise: more than exactly 910 (!). This means that
cells which contain more than 910 characters cannot be copied this way.
Now I have read somewhere that this limit can be bypassed by opening
both workbooks between which you want to copy in one single Excel
session.

So, does anybody Know how you manage to open a second Excel workbook in
an already existing Excel session by VBA/ macro?

Thanks for any hint on that!!!

Cheers
Markus