QueryInterface for interface Microsoft.Office.Interop.Excel._Application failed - Web Development Discussion Boards

call javascript function on pop-up menu item or link

pastecopy5-Jul-06 23:57

5-Jul-06 23:57

i want to call javascript function on pop-up menu item or link . how shall i do this ??? for example i have a pop-up menu with aboutus and contact us menu item or link . and i calljavascipt function when user click aboutus link . please help me regarding this problem .

RTF Applet

Maher Abu Zer5-Jul-06 22:06

Maher Abu Zer

5-Jul-06 22:06

Hi,

I'd like to use a text box in my web form that accepts and returns RTF format,
but i don't want it to be an activeX control
i don't anything to be prompted to the user when he uses the form so
I think it should be an applet,

so what should i do, and how to solve this problem?

thanx in advance

Regards,
Maher Abu Zer

Re: RTF Applet

theJazzyBrain5-Jul-06 23:00

theJazzyBrain

5-Jul-06 23:00

Could you please give some more information on what it is that you wana do?

Thank you.

Jason Kataropoulos

Excellence is not an act, but a habit!

Aristotle

Re: RTF Applet [modified]

Maher Abu Zer5-Jul-06 23:45

Maher Abu Zer

5-Jul-06 23:45

ok Jason,

i have a web form that contains two text boxes
first one is to be filled by question name
and the second one is to be filled by question details
question details text box will contain data such as:

Please Enter Your Name, and your last name
i want the user to be able to enter the text and format it in RTF,
then i can take the value from this text box as RTF and store it in database

because i have another vb.net desktop application that reads these data from the database
and displays it as RTF data

thanx

Regards,
Maher Abu Zer

-- modified at 5:47 Thursday 6th July, 2006

Re: RTF Applet

theJazzyBrain7-Jul-06 1:33

theJazzyBrain

7-Jul-06 1:33

I suggest you just store it as plain text... there shouldnt be a problem displaying it as RTF in your desktop app...

Jason Kataropoulos

Excellence is not an act, but a habit!

Aristotle

This is kinda noob for me to ask this but... [modified]

Neo_Odin5-Jul-06 20:47

Neo_Odin

5-Jul-06 20:47

<applet code="fphover.class" <b="">codebase="./" width="120" height="24">
<param name="color" value="#000080" />
<param name="hovercolor" value="#0000FF" />
<param name="textcolor" value="#FFFFFF" />
<param name="text" value="C Programming" />
<param name="effect" value="glow" />
<param name="url" valuetype="ref" value="http://metalab.uniten.edu.my/~azhana/indexCProg.html" />

ok,here's the deal. I got some assignments which is, getting a hover button to work properly.
The real assignment is, i HAD to GET SOME REPLY from u guys (it does not ave to be solving my assignment here). D'Oh! | :doh:

Just a reply, that's all.

But any sollutions to the codes above that u guys wanna offered are really needed coz hey, that's why this forum existed.
For us to help each other rite? Wink | ;)

As noob as i am... are there any such things as codebase values for any applet is "./" Confused | :confused:

-- modified at 2:48 Thursday 6th July, 2006

Re: This is kinda noob for me to ask this but...

kanes5-Jul-06 21:11

kanes

5-Jul-06 21:11

udin........ ada assigment ke???? hehhehehehe... dpt jawapan pass pada I .. k..

QueryInterface for interface Microsoft.Office.Interop.Excel._Application failed

kavithapuranik5-Jul-06 20:28

kavithapuranik

5-Jul-06 20:28

Hi,

im developing a web application using vb.net,where in im creating an excel sheet ,fillin the cells and saving it,
im using windows 2000,and i have installed office 2003.
in my application i have added reference to Excel and microsoft.office.core

in the code ,im using
Imports Excel = Microsoft.Office.Interop.Excel

and in page load ,i have wriiten
Dim excelobj As New Excel.Application
Dim xlBook As Excel.Workbook
Dim xlsheet As Excel.Worksheet
Dim i As Int32

Dim xlApp As Excel.Application
Dim xlBook As Excel.Workbook
Dim xlSheet As Excel.Worksheet
xlApp = CreateObject("Excel.Application")
xlBook = CType(xlApp.Workbooks.Add, Excel.Workbook)
xlSheet = CType(xlBook.Worksheets(1), Excel.Worksheet)

xlSheet.Cells(2, 2) = "This is column B row 2"
xlSheet.Application.Visible = True
xlSheet.SaveAs("C:\Test.xls")
xlApp.Quit()
xlApp = Nothing

im not getting any error when i compile ,but during execution,i get
"QueryInterface for interface Microsoft.Office.Interop.Excel._Application failed."

Exception Details: System.InvalidCastException: QueryInterface for interface Microsoft.Office.Interop.Excel._Application

failed.

Execption occurs here
xlBook = CType(xlApp.Workbooks.Add, Excel.Workbook)

pls help

thanks

kavitha

OO Javascript

Cool^ASL5-Jul-06 20:09

Cool^ASL

5-Jul-06 20:09

Hi,
I am new to Object Oriented Javascript.

I am making a javascript "class" as:

function MyClass{
     this.ajaxObj = new uniAjax();
     
     this.Start = function(url){
           this.ajaxObj.request({'url': uri , 'func': this.GetResponse}, 'Resp');
     }

     this.GetResponse = function(resp){
            alert(resp);
            this.ProcessResponse(resp);
     }

     this.ProcessResponse = function(resp){
            alert(resp);
     }
}

This uses an AJAX framework (uniAjax) for fetching data from the server.
The callback function GetResponse is able to receive the response, but the problem is that since this method is called externally by the framework, the identity of this is lost. Meaning that, ProcessResponse() is no longer related to the current this object... and therefore it gives an error when called as this.ProcessResponse(resp).

Can anyone please please please please provide a solution for this.

Thanks in advance.

*** Who said nothing is impossible? I have been doing it for a long time ***

Re: OO Javascript

Guffa5-Jul-06 22:05

Guffa

5-Jul-06 22:05

Make ProcessResponse a regular function instead of an anonymous function in an object, so that you can call it without a reference to the object.

---
b { font-weight: normal; }

Re: OO Javascript

Cool^ASL5-Jul-06 22:14

Cool^ASL

5-Jul-06 22:14

Hi Guffa,
Thanks for the reply.

Thats seems to be suitable solution, but my main concerns are:
1. will it be a problem if a method is accessed simultaneously from more than one place.

2. i somehow need object specific values to identify and differentiate different objects. If i put them in a global variable, then all the methods accessing this would certainly overwrite the existing value. Is there no way that i use AJAX and still retain the OO program ?

Thanks.

*** Who said nothing is impossible? I have been doing it for a long time ***

Re: OO Javascript

Guffa5-Jul-06 23:36

Guffa

5-Jul-06 23:36

Make a callback function for each object, that uses the instance of the object to call the method in it.

Or make a general callback function that somehow identifies what object the callback belongs to, and calls a method of that object.

---
b { font-weight: normal; }

problems with getting Front Page 98’s hover buttons

miss_aries5-Jul-06 19:55

miss_aries

5-Jul-06 19:55

I have a problem with getting Front Page 98’s hover buttons to function.

This is the applet code:

<applet code="fphover.class" codebase="./" width="120" height="24">
<param name="color" value="#000080" />
<param name="hovercolor" value="#0000FF" />
<param name="textcolor" value="#FFFFFF" />
<param name="text" value="C Programming" />
<param name="effect" value="glow" />
<param name="url" valuetype="ref" value="http://metalab.uniten.edu.my/~azhana/indexCProg.html" />

Can someone help my to solve this problem?

Thank You.

nas

Front Page 98 hover buttons problem..need help [modified]

MiSs.colly_cool5-Jul-06 19:39

MiSs.colly_cool

5-Jul-06 19:39

I'm in my web programming class and this is my first assignment..but i facing some trouble in understanding this codes..if anyone out there knows wat acctually this codes saying, do reply me as soon as posible..thanks Big Grin | :-D

the codes are as below:

<applet code="fphover.class" codebase="./" width="120" height="24">
<param name="color" value="#000080">
<param name="hovercolor" value="#0000FF">
<param name="textcolor" value="#FFFFFF">
<param name="text" value="C Programming">
<param name="effect" value="glow">
<param name="url" valuetype="ref"> value="http://metalab.uniten.edu.my/~coly_cool/indexCProg.html">
</applet>

THANKS...
SHAMINI KAMALASEN
MALAYSIA

-- modified at 1:48 Thursday 6th July, 2006

Problem with hover buttons [modified]

kanes5-Jul-06 19:26

kanes

5-Jul-06 19:26

I am having problems with getting Front Page 98’s hover buttons to function.
This is the list of codes.... can someone plz help me to solve this problem..
i reli need it soon

<applet code="fphover.class" codebase="./" width="120" height="24">
<param name="color" value="#000080">
<param name="hovercolor" value="#0000FF">
<param name="textcolor" value="#FFFFFF">
<param name="text" value="C Programming">
<param name="effect" value="glow">
<param name="url" valuetype="ref" value="http://metalab.uniten.edu.my/~kanes/indexCProg.html">
</applet>

Thanks

-- modified at 1:29 Thursday 6th July, 2006

Re: Problem with hover buttons

Neo_Odin5-Jul-06 19:55

Neo_Odin

5-Jul-06 19:55

Ahaahaha Kanes kene uat keje assignment!!!

Laugh | :laugh:

Re: Problem with hover buttons

Luqme5-Jul-06 20:59

Luqme

5-Jul-06 20:59

huahua .... macam kenal je soklan !!!

Luq

Web Service Deployment

vikashparida5-Jul-06 11:46

vikashparida

5-Jul-06 11:46

I want to deploy my web service on the internet. The problem I am facing is that my code references a dll (MySql.Data.dll).

When I am using the code on local host it seems to run fine, but on uploading to the server, the code cannot locate the dll.

I have tried putting the dll in the same as well as 'Bin' directory. Do I need to add something to the web.config file??

Internet explore not showing images [modified]

theprinc5-Jul-06 7:54

theprinc

5-Jul-06 7:54

1. I have a page that i developed, it shows fine in Mozzilla, but the images dont show in iexplore.
What can i do?

2.
2.1 How do i pass attriutes to another page using a hyperlink.
2.2 Is it possible to include a variable in a java script fuction?

I tried the following but it does not help, any clues?

<br />
<!--a href="threads.jsp" onclick=javascript: function(<% myvar%>)> </a--><br />
<br />
function(var)<br />
{<br />
    session.setAttribute("Myvar",var);<br />
}<br />

-- modified at 13:55 Wednesday 5th July, 2006

Re: Internet explore not showing images

Guffa5-Jul-06 9:17

Guffa

5-Jul-06 9:17

1. You can show some code.

2.1. Do you mean in the url?

<a href="page.jsp?key=value&anotherkey=anothervalue">

2.2. Yes. I don't know what technology you are using, but from the file type in the href property of the link, I assume that you are using JSP. I don't know how you write out values to the page in JSP, but I assume that it's similar to ASP:

<a href="threads.jsp" onwhatever="functionName(<%=myvar%>);"><br />
<br />
function functionName(var) {<br />
session.setAttribute("Myvar", var);<br />
}<br />
<br />
Substitute "onwhatever" with the event you are using.<br />
<br />
If the value is a string, however, you would surround it with apostrophes, the value should be html encoded, "\" should be replaced by "\\" and "'" should be replaced by "\'".<br />
 <br />
<br />
<small>---<br />
b { font-weight: normal; }</small>

problem in capturin co-ordinates in IE with scroll bars

navtejdhillon5-Jul-06 6:25

navtejdhillon

5-Jul-06 6:25

Hi I am using the following function in Ajax program,this is a part of it .The problem is the page in which I am using is quite big with scroll bars ,and in this senario ,I am not able to capture the co ordinates of the element that clicked the event to pin point location,and the div tag is displayed randomly.

// ItemDisplayLarge is the div in which reslut is to be displayed

function ViewSearchItem(e)
{

try
{

var left1=null;
var top1=null;
var nn6=document.getElementById&&!document.all;

if(nn6 == true)
{
left1 = e.pageX;
top1 = e.pageY;

}
else
{

left1 = event.clientX;
top1 = event.clientY;
}

top1=top1+20;
document.getElementById("ItemDisplayLarge").style.visibility="hidden";
document.getElementById("ItemDisplayLarge").style.top=top1+"px";
if(left1 > 400)
{
var x=left1-200;
document.getElementById("ItemDisplayLarge").style.left=x+"px";
}
else
{document.getElementById("ItemDisplayLarge").style.left=left1+"px";}

document.getElementById("ItemDisplayLarge").style.visibility="visible";
}
catch(ex)
{ex.message;}
}

Re: problem in capturin co-ordinates in IE with scroll bars

navtejdhillon5-Jul-06 6:47

navtejdhillon

5-Jul-06 6:47

Hi the answer is use

the propety of ie wiz page.scrollX(),page.scrollY()

so in the above code add

let say

var sX= page.scrollX();
var sY= page.scrollY();

top1=top1+ sY;
left1 =left1+sX; Laugh | :laugh:

the code works .
I was not able to find the solution intially thats why I posted the thread.

thanks

Navtej Smile | :)

Client info

TintinV3ck5-Jul-06 3:24

TintinV3ck

5-Jul-06 3:24

Hi, Does anyone know how to get client info regarding pc name, domain, etc. I need to gather that info from users on a local intranet using an internal website. I need to authenticate the user against the domain Active Directory.

Thanx

Regards,

Tintin

Re: Client info

Guffa5-Jul-06 4:11

Guffa

5-Jul-06 4:11

The you need to run an ActiveX component in the browser.

Why not just disallow anonymous login and let the users log in using their domain account?

---
b { font-weight: normal; }

Re: Client info

TintinV3ck5-Jul-06 20:18

TintinV3ck

5-Jul-06 20:18

I need automatic login when the user opens the web page. And security group levels should be managed by the admins of the AD. What kind of active x componet should i use, and this should run client side?? or not?

Regards,

Tintin

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.