In VBA, I want to use the options parameter like:
Set OPTIONS = MyFunc.Tables("OPTIONS")
OPTIONS.Value(1, "TEXT") = "OBJECT = 'S_TCODE'"
however when I then run the module it produces a system failure. If I comment out the two options lines then it runs with no problem with no filter on the data of course.
Any ideas how to correct this?