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() |
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 |