how to execute a small vb script

Question

0.00/5 (No votes)

See more:

I want to execute a small vb script file, for that I wrote the following code in the notepad and saved that notepad file as

"sampleScript.vbs" is that correct? please note the code that I have written. folowing error occured please help me

Error coming : Expected statement missing

Sourece: Vb complilation error

line : 1

Code
-------

XML

<html>
<body>
<script type="text/vbscript">
document.write("Hello World")
</script>
</body>
</html>

Posted 9-Aug-11 21:38pm

Ajain A K

Updated 9-Aug-11 21:42pm

Wendelius

v2

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Christian Graus · Answer 1 · 2011-08-09T21:49:00

Solution 1

This is not VBScript, not even close. It's HTML, with some VBScript that can only be viewed in a browser ( document.write is not VBScript per se, it relies on a document object existing, which is only true in a browser ). Save this as .htm and I believe IE will render it correctly. Any other browser will not, only IE can use VBScript. If you want to do scripting in a web page, then javascript is the way to go.

Posted 9-Aug-11 21:49pm

Christian Graus

Comments

Ajain A K 10-Aug-11 4:31am

Dear christian,

Thank you so much for the instant help from you that was fine answer. I am using Internet Explorer only. I want to ask an advice to you plese direct me

My requirment is that I want to do some programming for MS-Excel manipulation using vb script is that possible?

my exact requirment are:

1. I want to plot some graphs based on excel data input

2. I want to write some datas in excel cells

is that possible? please advice me.... if you can provide me some tutorials for that

CPallini · Answer 2 · 2011-08-09T22:06:00

Solution 2

As Christian already pointed out, your VBScript is embedded inside an HTML page, hence the correct file extension for your file is html (and, yes, you have to open it with Internet Explorer, other browsers like Firefox or Chrome don't support VBScript).
Even the tutorial from which you grabbed the code[^] is clear about.
On the other hand, if you wan't to create a 'stand-alone' VBScript, then the following line is just enough:

VBScript

MsgBox "Hello World"

save it as "hello.vbs" and double click to run (be sure to do it on a Windows machine).

Posted 9-Aug-11 22:06pm

CPallini

Updated 9-Aug-11 22:09pm

v3

Comments

Ajain A K 10-Aug-11 4:32am

Dear Pallini,

Thank you so much for the instant help from you that was fine answer. I am using Internet Explorer only. I want to ask an advice to you plese direct me

My requirment is that I want to do some programming for MS-Excel manipulation using vb script is that possible? my exact requirment

are:

1. I want to plot some graphs based on excel data input

2. I want to write some datas in excel cells

is that possible? please advice me.... if you can provide me some tutorials for that

CPallini 10-Aug-11 5:12am

Google is you best friend, search for "Excel Automation with VBScript", I found, for instance:
http://knol.google.com/k/excel-vbscript-automation#

Ajain A K 10-Aug-11 8:22am

Hi Pallini,

Thanks a lot, the link that you provided is very useful for excel automation.

CPallini 10-Aug-11 8:24am

You are welcome.