I have an array of filenames (file1.xls, etc.). I need to strip the ".xls" off of each item in the array. Does anyone have any help for me?
for i = 0 to UBound(YourArray)<BR> YourArray(i) = Left(YourArray(i),Len(YourArray(i))-4)<BR>next
you can use a vbscript (replace) function if you have a specific list of file extensions<BR><BR>