How to stop Interaction with excel

[Rayner]

While running one of my application, excel will be opened at the middle. I need to minimize the excel and stop interacting with it, which means even if I click the excel task bar it should not open excel. It should be always in minimized state.

I have an code which works in XP and is not working in Windows7. Can anyone please provide some solution which works on both XP and windows7.


Code Snippet: ( which works in XP )


ExcelObject.WindowState = xlMinimized
ExcelObject.Interactive = False

 

[bensonsearch]

Hi,
What language is your application in?

 

[Rayner]

Hi,
What language is your application in?

VB6 is the language we use..

 

[bensonsearch]

hmmm it may be something you need to post in a VB6 forum but,

ExcelObject.WindowState = xlMinimized

above should still work. never seen the interactive property before. question, what is it you are trying to accomplish? why open and leave there?

 

[Rayner]

hmmm it may be something you need to post in a VB6 forum but,

ExcelObject.WindowState = xlMinimized

above should still work. never seen the interactive property before. question, what is it you are trying to accomplish? why open and leave there?

It's not particularly VB6 code, we can take it as a VBA code also.
ExcelObject.WindowState = xlMinimized, will minimize the excel window. But if we click the excel from taskbar it will again open. ExcelObject.Interactive = False, will prevent opening excel from taskbar. It will stop the interaction with excel. This property is not working in windows 7. So, I think this post should be posted in excel forum. I just want to know is there any other way I can lock excel.

 

[Jaafar Tribak]

How about hiding the excel application instead of just minimizing it ? You can then unhide it when/if needed.