Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Script needs to search for value in Excel

Status
Not open for further replies.
robyno

robyno

IS-IT--Management
Sep 23, 2002
12
US
Help!

I am a newbie and have a macro that needs to check a large list of values to set the conditional path for a data entry script. This list of values that I have is around 6000 entries. My data entry fields will pass a value, example "1234" and I need to search for the numeric code assigned to "1234" in the excel spreadsheet and bring the value "2" back. Then the next record is read in and the value "2222" needs to be looked up and the numeric code "3" attached to it needs to be returned.

input record
1 1234
2 2222
3 3232

spreadsheet
1234 2
2222 3

If ReturnVal = 2 Then
.transmitString "X"
ElseIf ReturnVal = 3 Then
.transmitString "Y"

I hope someone can help, please!
 
Status
Not open for further replies.

Similar threads

bdwilcox
  • Locked
  • Question
Script seeing input variable value as blank but sees hard-coded value 4
Replies
6
Views
1K
bdwilcox
bdwilcox
bdwilcox
  • Locked
  • Question
Trying to adapt VBScript to search if machine is in an AD group 6
Replies
8
Views
1K
SoftwareRT
SoftwareRT
Brianfree
  • Locked
  • Question
Excel Rows to Column 1
Replies
2
Views
648
Brianfree
Brianfree
wchull
  • Locked
  • Question
How do I resolve this permissions error in my script?
Replies
0
Views
512
wchull
wchull
Katto
  • Locked
  • Question
Excel VBA functions in VBScript
Replies
4
Views
664
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top