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
|
|
|
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. |
|
|
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)
- Dec. 16, 2013, 03:14:35 PM EST
I don't know VBS, but this looks reasonable.
- (Another Scott)
- (1)
- Dec. 16, 2013, 03:49:31 PM EST
that second link was great, thanks!
-NT
- (boxley)
- Dec. 16, 2013, 08:45:59 PM EST