VBA is very similar to VBScript, but because can declare various data type
(not only variants) and make references, you can get the benefit of
Intellisense to help with syntax.
Also because you are within Excel, you already have the Application object
available.
You do not have to use the FSO, as you have the full range of file system
available to you from native VBA functions.
And, probably best of all, you get the benefit of the macro recorder
(ToolsMacroRecord New Macro...), to generate the basic code for you for
most actions in Excel.

As you are using Excel anyway, you may as well use VBA, as you do not seem
to have much reason not to.

NickHK

"Catherine Jackson" wrote in
message ...
Nick,

I never used VBA/Excel before. Would it be easier to do so? Any tips?

"NickHK" wrote:

Any reason you are using VBScript instead of Excel/VBA ?

NickHK

"Catherine Jackson" wrote
in
message ...
Hi,

I posted a message earlier but didn't get a response yet. I have a
deadline
so I was hoping that someone could help me.

thx,

Cathy

Original Message he

Hello,

I need to take Test Cases written in an excel spreadsheet in a
particular
format and use vbscript to go through the data and modify it. The end
resulting data will them be saved and placed in a different directory.

Here is the caveat. There are multiple steps to each test case.
There
are
multiple test cases in a spreadsheet. AND there are multiple
"sheets".
Can
someone please help me with this. Here is what I have so far, and it
works
for 1 test case (multiple steps). I want to repeat what this does,
but
when
there are multiple test cases in the spreadsheet. And when there are
no
test
cases left, the program needs to end.

What would be icing on cake would be if the code would go check and
see if
there are multiple "sheets", and if so, to do the same thing with
them.

Here is my code:
---------------------- CUT ---------------------