Path/File access error

[AndrewKent]

Hi there,

I am trying to get to large excel documents (both with userforms and coding totalling to 2Mb each) to communicate in the same Excel Application. However when one opens, it's fine, the second opens and I get the following error messages...

"Path/File access error"

"Cannot find specified object"

"System Error &H8000FFFF (-2147418113)"

...now if I shut them both down but leave the same Excel application open, I then can't open either again without recieving the same error messages.

Apart from trying to open two massive documents, is there something I'm doing wrong?

Andy