i have a string. let say

strMyString = "Array(,Rectangle,Oval,Circle,,)"

and i want my final result something like this

strMyString = "Array("Rectangle","Oval","Circle")"

i struggled a few days or so in VBA with many functions such as mid,instr,instrrev,loop. i know the problems are the characters before and after this mark "," (the comma ) however i'm still stuck.Can any of you can do this. Meanwhile i will do my best before check out this post again. any help is appreciated.