Problem with hover buttons [modified] - Web Development Discussion Boards

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

kavithapuranik5-Jul-06 20:28

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

DataGrid Binding through Ajax [modified]

vipinkapoor5-Jul-06 1:17

vipinkapoor

5-Jul-06 1:17

How to bind datagrid(asp.net web control) through ajax

vipin kapoor

-- modified at 7:17 Wednesday 5th July, 2006

ASP.NET Dynamic Web Menu Control

B.N.Prabhu4-Jul-06 3:41

B.N.Prabhu

4-Jul-06 3:41

ASP.NET Dynamic Web Menu Control based on JavaScript
I need a program which should read a Table and get Menu's Name and Dynamically create buttons in the "Top Frame" and i click any one button then it should display that relevant page in the "Right Frame" which is also in another one table.
Please any one help me how to do this.

JavaScript Problem

chandan_tandon4-Jul-06 1:28

chandan_tandon

4-Jul-06 1:28

i am opening a pop up through javascript but just buz of google toolbar it is not opening and when i choose unblock the popup my application doing exactly the right thing which i want i know there is a script or property in javascript which can open the block popup window

can any body tell me how i can do this in javascript

please tell me as soon as possible Smile | :)

bye

Re: JavaScript Problem

Guffa4-Jul-06 2:32

Guffa

4-Jul-06 2:32

Please use punctuation to separate the sentences from each other, and someone might be able to understand what you are trying to do.

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

Re: JavaScript Problem [modified]

RichardGrimmer4-Jul-06 3:12

RichardGrimmer

4-Jul-06 3:12

I think what you're trying to do is get your popup to circumvent a popup blocker....wouldn't be much of a blocker if you could do that now would it Smile | :)

AFAIK, popup blockers pre-process the page, and strip out most (if not all) of the javascript - esp anything that pops up a window, then renders the page. If you elect to allow popups, it re-renders with the missing bits et voila (that's why it posts back when you allow them).

You'll just have to tell people to unblock your site Smile | :)

"Now I guess I'll sit back and watch people misinterpret what I just said......"
Christian Graus At The Soapbox

-- modified at 9:13 Tuesday 4th July, 2006

How to disable addressbar and the menus?

rachgreen4-Jul-06 0:44

rachgreen

4-Jul-06 0:44

Can somebody help me how to disable the addressbar and the menus, for a web application being developed on C#.NET???
Confused | :confused:

Rach

IIS not in windows home edition??

campbells3-Jul-06 22:21

campbells

3-Jul-06 22:21

I heard there is no IIS in home edition, is it true? how about the professional and NT version? how do i active the IIS function?

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