Getting Data from Excel sheet and inserting it into a function

Forums

My Profile

Inbox

Address Book

My Subscription

My Forums

Getting Data from Excel sheet and inserting it into a function

Logged in as: Guest

arrSession:exec spGetSession 2,16,61921

	Active Users: There are 0 members and 0 guests.
	Users viewing this topic: none

Printable Version

All Forums >> [Scripting] >> Post a VBScript >> Getting Data from Excel sheet and inserting it into a function
Do you like VisualBasicScript.com? Link to us and help spread the word about our forum. Thanks!

Page: [1]

Message

<< Older Topic Newer Topic >>

Getting Data from Excel sheet and inserting it into a f... - 6/27/2008 1:40:56 AM

sreekanthg

Posts: 1
Score: 0
Joined: 6/27/2008
From: India
Status: offline

Greetings Team,

I have written a function to add a new account into my application. in this function i need to add fields like name, location, address, bank accoutnumber and so on.

Function AddNewPayerAccount()
vrefLoginBrowser.Link(Linkaddnewacc).Click
vrefLoginBrowser.WebEdit(ANAName).Set a "QTP Payer Account 1"
vrefLoginBrowser.WebEdit(ANADesc).Set "QTP Payer Account 1"
vrefLoginBrowser.WebCheckBox(ANAAccTypePF).Set "ON"
vrefLoginBrowser.WebCheckBox(ANAPayMetElec).Set "ON"
vrefLoginBrowser.WebButton(BankSelSave).Click
End Function

i want to provide the data of the fields in an excel sheet and then i want that to be set here.

Instead of doing like this
vrefLoginBrowser.WebEdit(ANAName).Set a "QTP Payer Account 1"
vrefLoginBrowser.WebEdit(ANADesc).Set "QTP Payer Account 1"

I want to write somthing like this where A and B are the cell value in the excel sheet that i am calling

vrefLoginBrowser.WebEdit(ANAName).Set A
vrefLoginBrowser.WebEdit(ANADesc).Set B

can any one of you help me in doing this as i am a learner it would be great help to me. thanks in advance

_____________________________

Sreekanth.G
94402 33336