$a=$path

$b = $a.indexof("=")     # so the first = is at character 9

 

$b = $b + 1

$c = $a.indexof(",")

$d = $c - $b

 

substring starts at the first character, in this case $b and then includes

the number of characters in your substring, in this case $d.

 

$e = $a.substring($b,$d)

 

 

Function MID($path) {
$a=$path
$b = $a.indexof("=")
$b = $b + 1
$c = $a.indexof(",")
$d = $c - $b
$e = $a.substring($b,$d)
$ws.Cells.Item($row,4) = $e      #This puts my substring in an Excel Spreadsheet in column 4

}