call excel macro in java or ASP

Colo

MrExcel MVP,

Joined

Mar 20, 2002

Messages

1,659

Office Version

1. 2016
2. 2003 or older

Platform

1. Windows

• Jul 3, 2003

• #2

Hi rekha,
Wht don't you use VBS??

Pls paste the code below in the Notepad and save as Test.vbs. Give it a try! FYI, you can use these kind of VBS code in HTML.

Code:

Dim objXL
Set objXL = CreateObject("Excel.Application")
With objXL
    .Workbooks.Open ("http://www.interq.or.jp/sun/puremis/colo/data/Book1.xls")
    .Application.Run "Test"
    .Application.Quit
End With
Set objXL = Nothing

 

Upvote 0

R

rekha

New Member

Joined

Jul 2, 2003

Messages

4

• Jul 7, 2003

• #3

Hi
I have tried running the code u have sent me .but it gives me a message network not found.

 

Upvote 0

Corticus

Well-known Member

Joined

Apr 30, 2002

Messages

1,579

• Jul 7, 2003

• #4

Hi rekha,

I'm going to venture a guess that you need to replace:

Code:

"http://www.interq.or.jp/sun/puremis/colo/data/Book1.xls"

with a reference to a file on your computer, not Colo's

HTH,

 

Upvote 0

R

rekha

New Member

Joined

Jul 2, 2003

Messages

4

• Jul 7, 2003

• #5

yaa I tried by replacing the code with reference to my file.when i run the file it gives me the error as Network not found

 

Upvote 0

Corticus

Well-known Member

Joined

Apr 30, 2002

Messages

1,579

• Jul 9, 2003

• #6

Firstly,

You do not need to change anything like I suggested above, Colo's code works fine on Windows 2000 with IE 6.0.2800.1106

The idea is, use VB script in a similar manner as VBA, but you need to include the script tag.

This example:

Code:

<script language="VBScript">
Sub entrance_onClick
MsgBox ("We have moved, you will be moved to www.TheIllumni.com!")
window.location="http://www.TheIllumni.com"
End Sub
</script>

<form>
<input type="button" name="entrance" value="Click me!">
</form>

Can be seen here:
http://www.theillumni.com/posts/vbs.htm

HTH,

 

Upvote 0

Corticus

Well-known Member

Joined

Apr 30, 2002

Messages

1,579

• Jul 9, 2003

• #7

One problem might be Netscape (I noticed I got a Netscape hit from this page). I don't believe Netscape supports VBScript. They want java.

 

Upvote 0

R

rekha

New Member

Joined

Jul 2, 2003

Messages

4

• Jul 9, 2003

• #8

Hi
I have tried but I am very new with VBscript.Where do u run this Vb script

 

Upvote 0

Corticus

Well-known Member

Joined

Apr 30, 2002

Messages

1,579

• Jul 10, 2003

• #9

You put it right in your HTML.

Click on the link above (hopefully you have Internet Explorer).

Then when the page opens, select view|source, and you'll see where I put my VBScript.

HTH,

 

Upvote 0