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)

Aim towards the Enemy.
95 ms