Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Excel automation

I'm automating Excel from asp.net application on window2000.
the application work fine on the developpement machine but not on the
production server.

when the runtime hit the second line of code:
Dim xl As New Excel.Application
Dim wb As Excel.Workbook = xl.Workbooks.Open("file.xls")
it throw this error:
"System.InvalidCastException: QueryInterface for interface
Excel._Application failed"

thanks for help

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 205
Default Excel automation

Hi Zino,

I'm automating Excel from asp.net application on window2000.
the application work fine on the developpement machine but not on the
production server.

when the runtime hit the second line of code:
Dim xl As New Excel.Application
Dim wb As Excel.Workbook = xl.Workbooks.Open("file.xls")
it throw this error:
"System.InvalidCastException: QueryInterface for interface
Excel._Application failed"


Excel is not designed to be run on a server in this manner. If you
search the Microsoft KB for 'Excel Server' you should find some
information about the (many) issues.

Regards

Stephen Bullen
Microsoft MVP - Excel
www.oaltd.co.uk


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel automation in MFC charian Excel Programming 0 July 20th 04 03:45 AM
C# Excel Automation Add-In Frank X Excel Programming 4 February 23rd 04 01:30 PM
Excel automation in a VB app [email protected] Excel Programming 1 January 12th 04 07:59 PM
Excel Com Automation Tom Ogilvy Excel Programming 5 November 10th 03 02:05 PM
Excel Web Automation mccaka Excel Programming 1 October 9th 03 02:18 AM


All times are GMT +1. The time now is 03:46 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"