What do you mean by "That didn't work" ?
If the user double-clicks on an Excel file, your instance of Excel will not
respond to the DDE request.
Assuming your instance is not visible, how is the user interacting with it ?

NickHK

wrote in message
oups.com...
On 18 Apr, 15:56, Jim Thomlinson <James_Thomlin...@owfg-Re-Move-
This-.com wrote:
Give this a try...

xlApp.IgnoreRemoteRequests = True
--
HTH...

Jim Thomlinson



" wrote:
I am using Visual Basics.NET to read data from an Excel file.
I am using the following code

Dim xlApp as Excel.Application
Dim xlBook as Excel._Worksheet

xlApp = CreateObject(Excel.Application)
xlBook = xlApp.WorkBooks.Open("path of Excel file")

------------------------------

This works fine but my problem is that if i open another Excel
document whilst my program is running the Excel document the program
has opened becomes visible to the user. If they then close Excel down
this closes down the document my program is using and causes errors.

Is there any way of stopping this?

Any help is much appreciated.

Kind Regards,

Tom Miller.- Hide quoted text -

- Show quoted text -

That didn't work i'm afraid.