467,161 Members | 972 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,161 developers. It's quick & easy.

Excel Intero DLL problem 2003

Guys,

I am having problems with Excel 2000 to Excel 2003 dll in production.

I am having version 2003 in my PC and I used the below code change to
open password protected excel files in my application. My application
is in ASP.NET

From:
objExcel = New Excel.Application
objExcel.Workbooks.Open(strFileName, , False)
To:
objExcel = New Excel.Application
objExcel.Workbooks.Open(strFileName, , False, ,
file_pwd.Trim)

The above change is working fine in my local PC.

I moved the code change into production where I had Excel 2000
version.

It did not work. I got an error:

Object reference not set to an instance of an object. at
Excel.Workbooks.Open(String Filename, Object UpdateLinks, Object
ReadOnly, Object Format, Object Password, Object WriteResPassword,
Object IgnoreReadOnlyRecommended, Object Origin, Object Delimiter,
Object Editable, Object Notify, Object Converter, Object AddToMru,
Object Local, Object CorruptLoad) at
SentryDotNet.FileParsing_FTP.FTPLoadFile(String strFileName, Int32
intClientID)
So I requested for Excel 2003 version in production and Server team
has installed Version 2003 in production server

Now I am getting different error as below

Server execution failed at
SentryDotNet.FileParsing_FTP.FTPLoadFile(String strFileName, Int32
intClientID)

I am really worried. I called server team and found out that they did
not restart the server after they installed 2003 version the reason
being it had not asked for restart.

Do we have to restart the server after installing 2003?

How to resolve the above issue?

Please help.. Do we have to register the Excel dll into production?
How to do this?

Please help.

Thanks.
Dec 13 '07 #1
  • viewed: 1411
Share:
2 Replies
* Don't use Excel on a server
* Try rebootting??

<sm********@gmail.comwrote in message
news:1d**********************************@e25g2000 prg.googlegroups.com...
Guys,

I am having problems with Excel 2000 to Excel 2003 dll in production.

I am having version 2003 in my PC and I used the below code change to
open password protected excel files in my application. My application
is in ASP.NET

From:
objExcel = New Excel.Application
objExcel.Workbooks.Open(strFileName, , False)
To:
objExcel = New Excel.Application
objExcel.Workbooks.Open(strFileName, , False, ,
file_pwd.Trim)

The above change is working fine in my local PC.

I moved the code change into production where I had Excel 2000
version.

It did not work. I got an error:

Object reference not set to an instance of an object. at
Excel.Workbooks.Open(String Filename, Object UpdateLinks, Object
ReadOnly, Object Format, Object Password, Object WriteResPassword,
Object IgnoreReadOnlyRecommended, Object Origin, Object Delimiter,
Object Editable, Object Notify, Object Converter, Object AddToMru,
Object Local, Object CorruptLoad) at
SentryDotNet.FileParsing_FTP.FTPLoadFile(String strFileName, Int32
intClientID)
So I requested for Excel 2003 version in production and Server team
has installed Version 2003 in production server

Now I am getting different error as below

Server execution failed at
SentryDotNet.FileParsing_FTP.FTPLoadFile(String strFileName, Int32
intClientID)

I am really worried. I called server team and found out that they did
not restart the server after they installed 2003 version the reason
being it had not asked for restart.

Do we have to restart the server after installing 2003?

How to resolve the above issue?

Please help.. Do we have to register the Excel dll into production?
How to do this?

Please help.

Thanks.

Dec 13 '07 #2
<sm********@gmail.comwrote in message
news:1d**********************************@e25g2000 prg.googlegroups.com...
I am having problems with Excel 2000 to Excel 2003 dll in production.
That's because Excel, like the rest of Office, is not designed to be run via
remote automation. In fact, it's so unstable in this environment that
Microsoft do not support it:
http://support.microsoft.com/default...US;q257757#kb2

Use this instead: http://www.aspose.com/Products/Aspose.Cells
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

Dec 13 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

17 posts views Thread by Mansi | last post: by
3 posts views Thread by Atley | last post: by
15 posts views Thread by =?Utf-8?B?c2hhc2hhbmsga3Vsa2Fybmk=?= | last post: by
reply views Thread by smtwtfs007@gmail.com | last post: by
4 posts views Thread by =?Utf-8?B?THluZXJz?= | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.