Microsoft excel not in dcomcnfg

EXE" without quote and then press enter. I'm so frustrated, I have similar issue. My app modifies a. I also get the error Microsoft Excel cannot access the file error. I gave permissions like irfangani said. Application ;. Worksheet oWB. Sheets[ "Exceptions" ];. Cells[1, 3]. Run "Module1. GetExceptionData" ;. SaveAs tempfile, FileFormat: 52 ;. Close null , null , null ;. Close ;. Quit ;. ReleaseComObject oXL ;. ReleaseComObject oSheet ;. ReleaseComObject oWB ;.

Replace ". Already wasted 2 full days :. Or how to get the Application Id of Excel. Also when I try to edit the permissions of any entry Some security settings?? I gave up and went a different direction. I don't know if my solution will help you, but instead of running my query and building the report in server-side Excel.

I put the report request in a queue for that user. I Response. Write the Xlsm file out, and when Excel Opens the file I have code in the Open Event that retrieves the request and builds the report on the client side, this way I totally avoid server-side Excel automation.

After wasting a whole day - Why do MS keep introducing crap like this that just makes everyone's lives miserable? Or do they think developers have nothing better to do than wade through all the restrictions they put in their way?

All the above solutions are working, if I am an administrator on the server. If, I remove my administrative access, I am able to download the excel on my application but the file is of 0 bytes. Thanks guys. This also helped me resolve Excel application issue on my ASP pages. Good work guys.! Otherwise To resolve this issue follow these steps:.

Office Office Exchange Server. Not an IT pro? Windows Client. Sign in. United States English. Ask a question.

Quick access. Search related threads. Remove From My Forums. Answered by:. Asked 6 years, 3 months ago. Active 6 years, 3 months ago. Viewed 3k times. Improve this question. What is the final goal of using dcomcnfg? Add a comment. Active Oldest Votes. However, if the entry is still missing after taking this step, or when on Windows 7 or Windows Server R2, try the following to resolve: Restart the Machine After an install of Office or a reboot of the operating system may be necessary for the appropriate reg keys to be added.

You will need to import this key from a working machine. Alternatively, you can check the permissions on the AppID key to make sure that the proper permissions exist for entries to be made to this registry key. Right click the AppID key and left click Permissions. Remember, if the checks in the boxes are grayed and cannot be checked or unchecked, this means they are inheriting permissions from their parent.

A black check mark means this key is not inheriting permissions from the parent and can be set here. Improve this answer. Shubham K Shubham K 5 5 bronze badges. Please suggest where I can give permissions to MS Excel Application so that my application runs without errors. Click 'Security' tab 5. Customize 'Launch and Activation Permissions' 6.

I'm not able to find it there. I reinstalled Office also, but still I couldn't find it there. Is there any workaround or solution? Best regards I found a solution to this problem by giving permissions at system level by following the steps below 1.

In the left tree structure, right click on My Computer and select Properties 3.