Writing and debugging VBS



Hi everyone

I've used the Visual Basic Editor in Word and Excel 2003 and have decided to
delve into VBS. I've managed to copy script samples from various sites,
paste them into Notepad and save the file with a .vbs extension. Needless
to say, the samples do what they're supposed to but, if I modify the code to
do something slightly different, it either works or it doesn't. If it
doesn't, an error messagebox is displayed which gives an idication of where
the error is.

I wonder if there's any software available to allow me to step through the
VBS and identify exactly what's happening as it runs, just as I can with the
VB editors in Word and Excel. I don't know if there's anything on my laptop
already (XP Pro SP2) or if I'd need third party software. Whilst experts
here are just that, I'd find it hard to believe that they can just generate
a perfect piece of complicated code out of thin air or debug it, almost as
if it's running in their heads!

Thanks for your time and patience.


.



Relevant Pages

  • Re: Writing and debugging VBS
    ... > I've used the Visual Basic Editor in Word and Excel 2003 and have ... > decided to delve into VBS. ... > just as I can with the VB editors in Word and Excel. ... This email account is my spam trap so I ...
    (microsoft.public.scripting.vbscript)
  • Re: How to open Access in VBS and leave it open
    ... I tried exactly that and Access closed when the script ended. ... When I open a database in Access, ... And of course in Excel, my VBS ...
    (microsoft.public.scripting.vbscript)
  • Re: How to open Access in VBS and leave it open
    ... When I open a database in Access, ... And of course in Excel, my VBS programs ... The problem is that unlike Excel, when the VBS terminates the Access ...
    (microsoft.public.scripting.vbscript)
  • Re: How to open Access in VBS and leave it open
    ... When I open a database in Access, ... And of course in Excel, my VBS programs ... The problem is that unlike Excel, when the VBS terminates the Access ...
    (microsoft.public.scripting.vbscript)
  • Re: How to open Access in VBS and leave it open
    ... think that proves the script isn't hanging around until Access is closed. ... UserControl property can be set in Visual Basic. ... as in Excel, it's just that an AccessObject has to be open to keep ... The problem is that unlike Excel, when the VBS terminates ...
    (microsoft.public.scripting.vbscript)