Running a macro from ASP 2.0 C# code on server using console application exe

Question

0.00/5 (No votes)

See more:

Hi All,
I wish to execute an excel with macros using ASP.NET 2.0 and C#. I tried using interop services and was able to execute in my local system but unable to do so in server. Then I created a console application to open the excel containing macros and again I was able to do in local system perfectly but not in server. The problem is when I run the exe manually (i.e by double clicking) I am able to see the excel macros being executed but when I try using website it just doesn't opens. Any Input on this is welcome!

Posted 14-Dec-10 22:49pm

imdarklord

Updated 15-Dec-10 5:53am

TweakBird

v2

Add a Solution

Comments

Dylan Morley 15-Dec-10 5:38am

OK so how are you executing the application on the server? You say you double click locally, but on the server 'I try using website it just doesnot opens.'

Please explain when you mean here. Is your website trying to execute the process? How are you starting the process? e.g. you use Process.Start

Also, any exception messages?

imdarklord 15-Dec-10 7:45am

Hi Dylan,
thanks for the reply. The macro in the excel connects to the database, copies the record in the workbooks, then again copies the whole workbook into a new workbook, stores the new workbook in a desired location.

My website picks the latest workbook from the location. I am using the exe to open the first excel(with macros). Using process.start I am executing the exe. This works fine in local system, but when i try to fire the exe from the website in server, it gives the file not found error as the new workbook is not copied in the desired location. Hope this clears your doubt.

Manfred Rudolf Bihy 15-Dec-10 9:39am

Is MS Excel installed on you webserver? What exactly do you mean by "picks the latest workbook from the location" ?

imdarklord 16-Dec-10 7:01am

Yes MS Excel is installed in the server and macros has been enabled. By latest workbook I mean the workbook that is created by the macro and stored in Temp folder. The website uses the Temp folder location to show this workbook in the download option to user.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Dylan Morley · Answer 1 · 2010-12-15T22:36:00

Solution 1

It's difficult to say without seeing all of the Macro code (which is probably where the error is occurring)

However, the fact that it's working locally and giving a 'file not found error' on the server makes me think you are using directory locations \ path strings in the Macro that don't exist on the server?

Double check your Macro code, look at all the places where you are referencing a path, e.g C:\Some Path\My Excel Documents\

Do the paths you reference exist on the server? Does the security context the process is executing under on the server have permission to the location?

Posted 15-Dec-10 22:36pm

Dylan Morley

Comments

imdarklord 16-Dec-10 7:03am

Dylan, when i execute the exe manually the new excel file is created in the temp folder that means there is no issue with the path that i have provided.

Dylan Morley 16-Dec-10 7:06am

OK so possibly due to the security. When running under the ASP.NET account, it may not have rights to certain directories.

Check the directories and make sure the ASP.Net account has Read\Write access to those locations

imdarklord 17-Dec-10 5:50am

Yes sir, the ASPNET has rights to perform read/write operations to the directory as other reports are also generated and temporarily saved in that particular folder.