Searching within EXCEL file and outputting answer

[D007Nomad]

Hi Guys

New to the forum, and still quite new to scripting with batch files..

So please bare with me..


Right so, this is what i'm trying to do.

I Have an excel file with 2 Columns

CODE(Columns A) Number(Columns B)

C001 55513689
C002 55513684
C003 55554893


Basically, I want to write a batch, or anything else that could be better - to search for the code, and output the number.

So.. You put in there "C003" and it outputs "55554893"


Thank youuuuu all

[Squashman]

Batch files cannot read Excel files. You will need to look at using Vbscript or Jscript.

[thefeduke]

If you save the spreadsheet as a .csv comma-delimited file you can work with this in batch:

Code: Select all

"C001",55513689
"C002",55513684
"C003",55554893

John A

[Matt Williamson]

This is a job for VBA in excel. Post it up in the Excel VBA forum on Stackoverflow Excel VBA and you'll get an answer but be sure to actually try something first.

[D007Nomad]

Can anyone assist with a VBS then?

[Squashman]

Can anyone assist with a VBS then?

No. That is out of scope of what this forum does. You were directed to post over on StackOverFlow.