Read excel and loop through the rows using VB script

Question

0.00/5 (No votes)

See more:

Hi all,

i have an excel something like
id Status Profit
1 Pass 1
2 Fail 2
3 Pass 6
4 Fail 4
5 Pass 5

now i should read this using VB script and iterate through rows to get all the Pass value added and the Fail value added (sum of both) in status column
how can i achieve this using VB script
Thanks in advance

What I have tried:

i have written the code to access the excel how to iterate through it

Posted 12-Apr-19 19:30pm

vin.ni.k

Updated 13-Apr-19 4:17am

Add a Solution

Comments

MadMyche 13-Apr-19 1:40am

Show us some code, so we know how the xl was read, and came aom you in the corrext direction

Richard MacCutchan 13-Apr-19 3:15am

Do you mean VB.NET or VBA?

1 solution

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)

#realJSOP · Answer 1 · 2019-04-13T04:17:00

Solution 1

If you're doing this in Excel, you don't need to write a script. You can do it with formulas.

Posted 13-Apr-19 4:17am

#realJSOP