If you instead of writing
filter = "[Name]='" & someName & "' and [Category]='" & someCategory & "' or [Value]='" & someValue & "'"
prefer to write
filter = Printf("[Name]='%0' AND [Category]='%1' OR [Value]='%2'", someName, someCategory, someValue)
then use this function
Function Printf(format...