I have a button on my Win form "Export to Excel". This button:
a. Will first check if the file "Mydata.xls" is already open. This is done using the processes in Task Manager.
b. If file already open, prompt user to close file.
c. Export the grid data to MyData.xls file
d. Open this file in Excel.
I tested my app with administrator login and I also created comp1 user as normal user and found that it works ok.
But at my clients end, with administrator login, it works ok but with normal user it gives error: Couldn't get process information from remote machine.
But with the same normal user, they can open the Excel application which means that they have sufficient rights to access Excel app. Then why do we get error when opening the file with regular user.
My feeling is that the problem should be in (a) or (d). What is the solution?