VBA Some way to pass Data to another Application(Instance) of Excel

You should be able to open the first file; then open Excel again using the Start menu shortcut, which should open a second instance, from which you open the second file.

Opening the "Report" as another excel application is not the problem, transferring or pasting values is...

Example for the OP...

Thank you for the reply, I have included some of my code in your example to demonstrate the type of text I need to pass through.
Most importantly, when the Public Enum is not deactivated, every time the code finds an application it gives a compile error for Invalid qualifier.

cytop, your code works nicely!

I've been trying to figure out how to manipulate the other Excel Application(Report) and I've come to realize that is not very simple.
Probably because I don't quite understand exactly how your code works.

I've tried to update some links between the 2 applications using:

Please Login or Register  to view this content.

...which was an utter failure! I doubt that this is even possible.

To circumvent the external formulas, I've tried to use the same copy/paste method on a Range that is larger than a single cell and I've found out
that can't be pasted in a single cell(much like right click, paste) and even when the copied range has the same size as the destination Range, I
still got an error that it's NOT the same size!?

I did manage to use a loop for pasting the cells one by one, which is an improvement but still quite slow.
Generally, I've found out that this is a headache and it cost me 3 days of my vacation, yet it still worth every second spent if I finally get this to work. (Any further aid would be also appreciated)

Thanks again, the least I could do is add rep.