473,326 Members | 2,136 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Excel Automation in JScript.Net

Hello,
I'm trying to migrate an Asp Webapp in Asp.Net. I'm just using the follwing
JScript.Net code:

var objExcel = new ActiveXObject("Excel.Application");
objExcel.Visible = false;
objExcel.DisplayAlerts = false;

On a WinXP Pro with Office 2003, it works. But on a Win2K Office XP, it
doesn't work, I receive the following error: "Old format or invalid type
library (System.Runtime.InteropServices)" for the "objExcel.DisplayAlerts"
line.

If possible, I would like to not use .Net codebehind and namespace (it would
be too much code to rewrite).
Thanks by advance.

Franky.
Nov 18 '05 #1
3 1842
This article might help:
http://www.aspnetpro.com/NewsletterA...200309so_l.asp

--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://Steve.Orr.net
"Franky" <fn*****@lcf-com.removethis.com> wrote in message
news:%2******************@TK2MSFTNGP10.phx.gbl...
Hello,
I'm trying to migrate an Asp Webapp in Asp.Net. I'm just using the follwing JScript.Net code:

var objExcel = new ActiveXObject("Excel.Application");
objExcel.Visible = false;
objExcel.DisplayAlerts = false;

On a WinXP Pro with Office 2003, it works. But on a Win2K Office XP, it
doesn't work, I receive the following error: "Old format or invalid type
library (System.Runtime.InteropServices)" for the "objExcel.DisplayAlerts"
line.

If possible, I would like to not use .Net codebehind and namespace (it would be too much code to rewrite).
Thanks by advance.

Franky.

Nov 18 '05 #2
Hello Steve,
thanks for your quick response, but... the link doesn't work ! I can't
browse DNS www.aspnetpro.com.
Any idea ? Or do you have a copy of this article ?
Thanks a lot.

Franky.

"Steve C. Orr [MVP, MCSD]" <St***@Orr.net> a écrit dans le message de
news:uf****************@TK2MSFTNGP10.phx.gbl...
This article might help:
http://www.aspnetpro.com/NewsletterA...200309so_l.asp
--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://Steve.Orr.net
"Franky" <fn*****@lcf-com.removethis.com> wrote in message
news:%2******************@TK2MSFTNGP10.phx.gbl...
Hello,
I'm trying to migrate an Asp Webapp in Asp.Net. I'm just using the

follwing
JScript.Net code:

var objExcel = new ActiveXObject("Excel.Application");
objExcel.Visible = false;
objExcel.DisplayAlerts = false;

On a WinXP Pro with Office 2003, it works. But on a Win2K Office XP, it
doesn't work, I receive the following error: "Old format or invalid type
library (System.Runtime.InteropServices)" for the "objExcel.DisplayAlerts" line.

If possible, I would like to not use .Net codebehind and namespace (it

would
be too much code to rewrite).
Thanks by advance.

Franky.


Nov 18 '05 #3
It's working now. It must have been a temporary glitch.

--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://Steve.Orr.net
"Franky" <fn*****@lcf-com.removethis.com> wrote in message
news:OA**************@TK2MSFTNGP09.phx.gbl...
Hello Steve,
thanks for your quick response, but... the link doesn't work ! I can't
browse DNS www.aspnetpro.com.
Any idea ? Or do you have a copy of this article ?
Thanks a lot.

Franky.

"Steve C. Orr [MVP, MCSD]" <St***@Orr.net> a écrit dans le message de
news:uf****************@TK2MSFTNGP10.phx.gbl...
This article might help:

http://www.aspnetpro.com/NewsletterA...200309so_l.asp

--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://Steve.Orr.net
"Franky" <fn*****@lcf-com.removethis.com> wrote in message
news:%2******************@TK2MSFTNGP10.phx.gbl...
Hello,
I'm trying to migrate an Asp Webapp in Asp.Net. I'm just using the

follwing
JScript.Net code:

var objExcel = new ActiveXObject("Excel.Application");
objExcel.Visible = false;
objExcel.DisplayAlerts = false;

On a WinXP Pro with Office 2003, it works. But on a Win2K Office XP, it doesn't work, I receive the following error: "Old format or invalid type library (System.Runtime.InteropServices)" for the "objExcel.DisplayAlerts" line.

If possible, I would like to not use .Net codebehind and namespace (it

would
be too much code to rewrite).
Thanks by advance.

Franky.



Nov 18 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Agoston Bejo | last post by:
Hi, is there somewhere a file that holds constants for Excel Automation ActiveX objects, such as adovbs.inc for ADO constants? Thx
17
by: Ange T | last post by:
Hi there, I'm having pain with the VB behind an Access form. The form is used to create reports in Excel based on the details entered in the form. This has always worked without error on my...
7
by: taylor.bryant | last post by:
I am running: Win XP SP2 Excel 2002, Access 2002 (Office XP SP3) Using Visual Basic (not VB.NET) At one point (prior to XP SP2?!? - I can't pin it down), this did not happen and I was easily...
1
by: cybertof | last post by:
Hello, Is there a way to connect (through automation) a c# application to a running Excel 2003 instance on a specific workbook ? In the past, i used to use GetObject(...) function in VB6. ...
17
by: Mansi | last post by:
I need to do some research on how to use excel automation from c#. Does anyone know of any good books related to this subject? Thanks. Mansi
12
by: D. Shane Fowlkes | last post by:
This most likely belongs in another forum but I thought I'd start here. I have a COM Object written in VB6. The DLL will access MS Excel and use it's Object Library to write a customized report...
3
by: Carlos Magalhaes | last post by:
Hey All, I am doing some excel automation using the excel COM. I can do most of the functions and its working well until I come across a formula. I can run a formula and insert the formula...
3
by: Mitchell Vincent | last post by:
Does anyone have some good examples of Excel automation with (VB).NET? I have some Excel spreadsheets that a customer needs parsed out but I've never tried to use Excel programatically before! ...
6
by: a.theil | last post by:
Please help! I need a simple excel automation, just 2 write some files into excel. I do: Dim oXL As Excel.Application Dim oWB As Excel.Workbook Dim oSheet As Excel.Worksheet Dim oRng As...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.