Working with Sub function with Excel in background

[sphinx_ps]

Hi,

I have a problem with Excel when it is working in background.
I'm calling a function from external program. Function is just Excel Sub function.

Please Login or Register  to view this content.

When I put some other application in front of Excel window the "CopyRange" doesn't paste the data.

Is there some option to continue calculation when Excel in background?

[shg]

That's not a valid function signature in VBA, and I don't know what you mean by "background"

[sphinx_ps]

Syntax is not so important. The point is that SUB isn't working when...
For example I have two application Photoshop and Excel. When Photoshop is active Window (currently selected) the SUB isn't pasting records in the sheet. When Excel is active window it works ok.

[shg]

Syntax is only important if you need the code to work.

What's calling the sub?

[sphinx_ps]

I call it from external application (Delphi program) every minute. When Excel is not active window the Sub function doesn't work.

By the way I have Sub and Functions in my .xla file Functions are working. I really don't understand this issue with Sub.

[shg]

Does it run? Set a breakpoint.

[sphinx_ps]

It runs but the data is not being pasted. It is pasted only when Excel is active window. (((

[shg]

I don't have any way to test, so I have no suggestion, sorry.