Pingu14

ok, i have this script to search a text file for a variable


Set objFSO = CreateObject("Scripting.FileSystemObject")
Set objTextFile = objFSO.OpenTextFile ("C:\Documents and Settings\FAMILY\Desktop\book1.csv", 1)

strNextLine = objTextFile.Readline
arrList = Split(strNextLine , ",")

If arrlist(0) = "" Then
For i = 1 to Ubound(arrlist)
Wscript.Echo "date: " & arrlist(i)
Next
end if

Now, i wan to be able to have an Inputbox set the variable for arrlist(0), unfortuneately when i put in an inpu box, it does not recgnise the Ubound function. Can somebody please help me out!

BaldEagle

I am sometimes a little dense, so please indulge me. How is the input box to interact with this script?

BaldEagle

__________________
If you can't be kind, at least have the decency to be vague.

You may be only one person in the world, but you may also be the world to one person.

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names, and all are different colors, but they all manage to live comfortably in the same box.

skuinders

I'm sure this person solved this problem by now (or gave up), but for the record I think what he was doing wrong was passing the actual textbox and not the string... so to solve his problem he would simply have to use .value

this is at least what I can gather from his rather convoluted explaination of the problem

__________________
"A stupid man's report of what a clever man says can never be accurate, because he unconciously translates what he hears into something he can understand."
- B. Russell

http://web.bryant.edu/~srk2