Error while publishing the application to server

[nudrat]

Hi All,
The scenario is as follows:
In my application, I am manipulating with Excel files. Reading , copying some values etc. It works fine as long as it is running from working directory (Local system).
I am publishing this application to a web server by publishing web site option from Build Menu in Visual studio editor. it gives error that Its unable to open the file.
the location where the Excel file are placed are within the application only..
Plz have a look n give some suggestion.

[JosAH]

Hi; I removed your other identical thread. There is no need to double post.

kind regards,

Jos (moderator)

[nudrat]

actually after posting the first post, I was unable to view that.. That's why I posted again with the same content.

Regards
Nudrat

[r035198x]

actually after posting the first post, I was unable to view that.. That's why I posted again with the same content.

Regards
Nudrat

If you want to view all threads you've started just click the My Subscriptions link near the top of the page.

P.S How are you specifying the path to your excel files?

[kenobewan]

Hi All,
The scenario is as follows:
In my application, I am manipulating with Excel files. Reading , copying some values etc. It works fine as long as it is running from working directory (Local system).
I am publishing this application to a web server by publishing web site option from Build Menu in Visual studio editor. it gives error that Its unable to open the file.
the location where the Excel file are placed are within the application only..
Plz have a look n give some suggestion.

Most errors of this nature occur from absolute local paths or permission probs. What was the error meesage and was there an error number?

[nudrat]

in the begining Files were there in the application itself, and I was reading it through Server.Mappath() method. But as it was giving problem, so I tried to write a function , which just creates an instance of Excel Application. the code is as follows: this code is in VB.NET

Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
fnReadExcel("ServerName")
End Sub

Public Function fnReadExcel(ByVal ServerName As String) As Boolean
On Error Resume Next
objApp = GetObject(ServerName, "Excel.Application")
If Err.Number Then
Err.Clear()
objApp = CreateObject("Excel.Application", ServerName)
End If
If objApp Is Nothing Then
Return False
End If
Return True
End Function

It is working fine, till it is there at local system. when I am publishing this to server, it is unable to create the instance of Excel. Moreover, my Local system is acting as a Server.
Please have a look n provide solution.

Regards
Nudrat