IWETHEY v. 0.3.0 | TODO
1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User
IWETHEY Banner

Welcome to IWETHEY!

New excell variable question or vb script
I have 234 directories with files named directory--foo.txt directory-bar.txt
foo and bar are the same as the contents of column a
how would I use a variable to sequentially put a heading of directory and then go down the column =$dir--columna
and actually populate the cell with a link
\server$dir$dir$dir--columna.*

Any opinions expressed by me are mine alone, posted from my home computer, on my own time as a free American and do not reflect the opinions of any person or company that I have had professional relations with in the past 58 years. meep
New I don't know VBS, but this looks reasonable.
If it were me, I'd use Python and xlrd/xlwt - http://www.python-excel.org/ , or save the XLS file as a CSV and write a script in an editor, but I don't know VBS so it's the hammer/nail problem.

Since you shouldn't be limited by what I know, ;-) , this may give you some VBS ideas - it sounds similar.

http://www.tek-tips....d.cfm?qid=1167426

HTH!

Cheers,
Scott.
New that second link was great, thanks!
Any opinions expressed by me are mine alone, posted from my home computer, on my own time as a free American and do not reflect the opinions of any person or company that I have had professional relations with in the past 58 years. meep
     excell variable question or vb script - (boxley) - (2)
         I don't know VBS, but this looks reasonable. - (Another Scott) - (1)
             that second link was great, thanks! -NT - (boxley)

I see mass suicides and riots in the future as every urkel fashion sense inspired computer nerd throws down their oxy pads and mutters, "enough is enough," then takes to the streets, scsi cards in hand, and it will be dark, dark day indeed my friend.
44 ms