Re: Can't find script debugger
From: Text (mas_at_mas.com)
Date: 02/26/04
- Next message: Guy: "Re: Item property in Collections..."
- Previous message: Robert Cohen: "Re: Can't find script debugger"
- In reply to: Robert Cohen: "Re: Can't find script debugger"
- Next in thread: Michael Harris \(MVP\): "Re: Can't find script debugger"
- Reply: Michael Harris \(MVP\): "Re: Can't find script debugger"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 26 Feb 2004 14:46:26 -0500
I'm not worried about the script at the moment, its just the third I've
written and its more of atest than anything else. I just want to be able to
step - by -step debug it. The debugger doesn't even open when I use the
primal script 3.1 trial.
here is the script though
Dim sfile,otextbox,counter,i
'Open the file
sfile = "C:\master\master.xls"
'open the spread***
Set oSheet = objXL.ActiveWorkbook.Worksheets(2)
'check and create the text files
Set fso = wscript.CreateObject("Scripting.FileSystemObject")
If ofs.FileExists("C:\master\results.csv") Then
vbsript.echo "file exists"
else
vbsript.echo "file exists"
end if
'open excel
Set objXL = WScript.CreateObject("Excel.Application")
Objxl.workbooks.open(sfile)
'disply the name of the ***
Wscript.Echo "The *** name is: " & o***.Name
'open text file for writing
fs = createobject( "Scripting.FileSystemObject" );
fs.CreateTextFile( "C:\master\output.csv");
os = fs.GetFile( "C:\master\output.csv" );
os = os.OpenAsTextStream( forwriting, 2 );
' start procedure the runs trough the script. 3 spaces in a row = end of
work***
i=1
counter = 0
Do until counter > 3
xlvalue = o***.cells(i,2).value
adminvalue = o***.cells(i,3).value
If xlvalue = "" then
counter = counter +1
Else
counter = 0
End if
'display values
wscript.echo "B"&i& "=" & xlvalue
wscript.echo "counter = " & counter
i=i+1
os.write( xlvalue,adminvalue\r\n );
loop
"Robert Cohen" <dont@want.spam.com> wrote in message
news:O7sjQ1J$DHA.3284@TK2MSFTNGP09.phx.gbl...
> you didn't show your script.
>
> --
> Robert Cohen
> A legend in his own mind
> --
>
> "Text" <mas@mas.com> wrote in message news:403e40b7$1_2@127.0.0.1...
> > I run my vbs script using the following command line and get a box that
> > tells me there is a syntax error. Then another box pops up and asks me
to
> > select a debugger, but the list is empty
> >
> > I installed the microsoft script debugger, but its dated 1997 and let me
> run
> > vbs files, just open them. Thanks in advance.
> >
> >
> > Mas
> >
> >
> >
> >
> > ----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet
> News==----
> > http://www.newsfeed.com The #1 Newsgroup Service in the World! >100,000
> Newsgroups
> > ---= 19 East/West-Coast Specialized Servers - Total Privacy via
Encryption
> =---
>
>
----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeed.com The #1 Newsgroup Service in the World! >100,000 Newsgroups
---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =---
- Next message: Guy: "Re: Item property in Collections..."
- Previous message: Robert Cohen: "Re: Can't find script debugger"
- In reply to: Robert Cohen: "Re: Can't find script debugger"
- Next in thread: Michael Harris \(MVP\): "Re: Can't find script debugger"
- Reply: Michael Harris \(MVP\): "Re: Can't find script debugger"
- Messages sorted by: [ date ] [ thread ]