need help

Forums

My Profile

Inbox

Address Book

My Subscription

My Forums

need help

Logged in as: Guest

arrSession:exec spGetSession 2,2,65434

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

Printable Version

All Forums >> [Scripting] >> WSH & Client Side VBScript >> need help
Do you like VisualBasicScript.com? Link to us and help spread the word about our forum. Thanks!

Page: [1]

Message

<< Older Topic Newer Topic >>

need help - 10/22/2008 9:18:42 PM

vb_newbie

Posts: 1
Score: 0
Joined: 10/22/2008
Status: offline

hi friends,

my question may be silly but please note i am very new to scripting

I have done the following code

but it results in error, "Specify the parameter using a text string or numerical index value.will you please let me know "

will you please tell me how to resolve the issue....

Set ExcelObj = CreateObject("Excel.Application")
ExcelObj.WorkBooks.Open "C:\Documents and Settings\Deepa\Desktop\password.xls"
Set currentWorkSheet = ExcelObj.ActiveWorkBook.WorkSheets(1) 'first sheet
testData = DataTable(admin, dtGlobalSheet)
ExcelObj.Application.Quit

Thanks

Post #: 1

RE: need help - 10/23/2008 12:23:41 AM

ebgreen

Posts: 5251
Score: 31
Joined: 7/12/2005
Status: offline

For this line:

testData = DataTable(admin, dtGlobalSheet)

Nothing in there is defined. Where is the DataTable function defined? What does the admin variable hold? What does the dtGlobalSheet variable hold?

_____________________________

"... when you are good and crazy, oooh, oooh, oooh, the sky is the limit!" - The Tick
Goog places to start:http://www.visualbasicscript.com/m_24727/tm.htm
http://www.visualbasicscript.com/m_47117/tm.htm

(in reply to vb_newbie)