How do I protect my hidden Excel.Application object from unwanted user interaction.

W

wijwoj

Hi folks,

I'm writing a little app in VB and it is based on a massively
complicated excel spreadsheet that I read and write to regularly. I
therefore keep the Excel.Application object open hidden in the
background.

My question is this. Is there a way of protecting the application
instance, so that when a user randomly opens any other excel
spreadsheet when the program is running, the spreadsheet they have
chosen to open does not use the invisible instance of excel in use by
my program?

The reason I ask is because by using this instance they make it
visible, and can also close it......which results in my program dieing.


Is there any way of doing this. Does anyone understand what I'm on
about?

Cheers,

Wij.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

excel 2007 add-ins and other VBA hidden files. General information 2
Accessing Excel from Word. 0
Do I need DLL or COM Addin, Excel Addin 1
Out of resources error message - when not... 3
Hidden copy of Excel 6
How do i password protect my VB Code from users 2
How to keep an instance of Excel away from the user? 9
How do I import a .dat file into excel using VB scripting? 2

Top