Automation & Windows 2000

[Alfredo Magallón Arbizu]

Hello,

I have an ASP.NET application that reads an Excel file through automation.

The app has a loop until first cell of a row is blank.

While the app works perfectly under Windows 2003, it fails under Windows 200
(Bad Variable Type, Interop.COMException)

Same versions of Office (XP) on both machines.

Excel 10.0 COM library referenced in project.

Any idea about this problem?

Thanks,
Alfredo

[Yan-Hong Huang[MSFT]]

Hello Alfredo,

Please also refer to KB aritlce "INFO: Considerations for Server-Side Automation of Office"
[url]http://support.microsoft.com/?id=257757[/url]

Hope that helps.

Best regards,
Yanhong Huang
Microsoft Online Partner Support

Get Secure! - [url]www.microsoft.com/security[/url]
This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------
!X-Tomcat-ID: 146674527
!References: <e7eY#EdVDHA.656@tk2msftngp13.phx.gbl>
!MIME-Version: 1.0
!Content-Type: text/plain
!Content-Transfer-Encoding: 7bit
!From: [email]yhhuang@online.microsoft.com[/email] (Yan-Hong Huang[MSFT])
!Organization: Microsoft
!Date: Thu, 31 Jul 2003 06:15:42 GMT
!Subject: RE: Automation & Windows 2000
!X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet
!Message-ID: <2yxf6syVDHA.2000@cpmsftngxa06.phx.gbl>
!Newsgroups: microsoft.public.dotnet.framework.aspnet
!Lines: 43
!Path: cpmsftngxa06.phx.gbl
!Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.framework.aspnet:163651
!NNTP-Posting-Host: TOMCATIMPORT2 10.201.218.182
!
!Hello Alfredo,
!
!I am not sure of what happened exactly now since you are using the same version of Excel. Could you please test the
!following:
!
!1) Rebuild the program under window 2000 to see if it works.
!2) Post the function which caused the error here.
!3) Checked the framework version on these machine to see if they are the same.
!
!If the problem is still there, please post here. Thanks.
!
!Best regards,
!Yanhong Huang
!Microsoft Online Partner Support
!
!Get Secure! - [url]www.microsoft.com/security[/url]
!This posting is provided "AS IS" with no warranties, and confers no rights.
!
!--------------------
!!From: "Alfredo Magallón Arbizu" <ama@fullstep.com>
!!Subject: Automation & Windows 2000
!!Date: Tue, 29 Jul 2003 14:59:24 +0200
!!Lines: 19
!!X-Priority: 3
!!X-MSMail-Priority: Normal
!!X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
!!X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
!!Message-ID: <e7eY#EdVDHA.656@tk2msftngp13.phx.gbl>
!!Newsgroups: microsoft.public.dotnet.framework.aspnet
!!NNTP-Posting-Host: 212.145.137.209
!!Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftn gp13.phx.gbl
!!Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.framework.aspnet:162955
!!X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet
!!
!!Hello,
!!
!!I have an ASP.NET application that reads an Excel file through automation.
!!
!!The app has a loop until first cell of a row is blank.
!!
!!While the app works perfectly under Windows 2003, it fails under Windows 200
!!(Bad Variable Type, Interop.COMException)
!!
!!Same versions of Office (XP) on both machines.
!!
!!Excel 10.0 COM library referenced in project.
!!
!!Any idea about this problem?
!!
!!Thanks,
!!Alfredo
!!
!!
!!
!
!
!