Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to reject user operation on the application I created
Hello everyone
I am working on a program about searching data from all the .xls files, But when I let my program run (user cannot see this program, because this program is run as a windows service), if the user open a .xls file, it seems myprogram and the file user opened will share a same Excel application--and the result is when user look at his file, he can also see the file open and close by my program How can I reject the operation from users? I tried 2 ways, but same result Here is the key part in my program(vb 2005): Private m_exlApp As Excel.Application ' Excel Application ...... ' for every filepath Dim excelBook As Excel.Workbook Dim sheet As Excel.Worksheet m_exlApp.Workbooks.Open(filepath, ReadOnly:=True) excelBook = m_exlApp.ActiveWorkbook For Each sheet In excelBook.Sheets ' do something Next excelBook.Close() ....... m_exlApp.Quit() |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to reject user operation on the application I created
The Excel instance opened through automation shouldn't be visible. Make sure
you don't have any line like this in your code: m_exlApp.Visible = True If you need the Excel instance to be visible, you can set the Interactive property to false. m_exlApp.Interactive=False "How to reject user operation" wrote: Hello everyone I am working on a program about searching data from all the .xls files, But when I let my program run (user cannot see this program, because this program is run as a windows service), if the user open a .xls file, it seems myprogram and the file user opened will share a same Excel application--and the result is when user look at his file, he can also see the file open and close by my program How can I reject the operation from users? I tried 2 ways, but same result Here is the key part in my program(vb 2005): Private m_exlApp As Excel.Application ' Excel Application ..... ' for every filepath Dim excelBook As Excel.Workbook Dim sheet As Excel.Worksheet m_exlApp.Workbooks.Open(filepath, ReadOnly:=True) excelBook = m_exlApp.ActiveWorkbook For Each sheet In excelBook.Sheets ' do something Next excelBook.Close() ...... m_exlApp.Quit() |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to reject user operation on the application I created
Thanks a lot Vergel Adriano
I didn't use visible currectly, thank you for reminding me. I didn't well explain my problem, my real problem is I want to reject user access to the Excel process I created. for example: I created a Excel Process(Process Id is 1868---allocated by OS ), and when user open a excel file, I don't want user to share the same process. I want to create a Excel process only for my program. Is there any method. "Vergel Adriano" wrote: The Excel instance opened through automation shouldn't be visible. Make sure you don't have any line like this in your code: m_exlApp.Visible = True If you need the Excel instance to be visible, you can set the Interactive property to false. m_exlApp.Interactive=False |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to reject user operation on the application I created
This will not allow the Shell to interact with your instance through DDE,
i.e. double-clicking and Excel file in Explorer: Application.IgnoreRemoteRequests = True It is still accessible via COM, but the user cannot inadvertently use that. NickHK "How to reject user operation" m wrote in message ... Thanks a lot Vergel Adriano I didn't use visible currectly, thank you for reminding me. I didn't well explain my problem, my real problem is I want to reject user access to the Excel process I created. for example: I created a Excel Process(Process Id is 1868---allocated by OS ), and when user open a excel file, I don't want user to share the same process. I want to create a Excel process only for my program. Is there any method. "Vergel Adriano" wrote: The Excel instance opened through automation shouldn't be visible. Make sure you don't have any line like this in your code: m_exlApp.Visible = True If you need the Excel instance to be visible, you can set the Interactive property to false. m_exlApp.Interactive=False |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to reject user operation on the application I created
Mr/Ms NickHK, it works well
and also the advice from Vergel is also very helpful Thanks a lot! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change cut/paste operation to cut/insert operation | Excel Programming | |||
Excell Problem when opening file created in another application!! | Excel Discussion (Misc queries) | |||
Open file in the application that created it | Excel Programming | |||
User-Defined Function Unusual Operation, Again | Excel Programming | |||
Unusual Operation of a User Defined Function | Excel Programming |