I am using VB 6.0 and Access 97.

I have a project where I need to check many access tables and
spreadsheets for proper dates and figures. So what I wanted to do is
have a table driven commands. I could hard code where to look in
Excel, or have table full of commands.

I want to put the following command in a field called VBCommand

Mid(ws.Range("F1")).Value, 6, 11)

In the code, I want cCommand = myTable("VBCommand") etc . . .

Then I want to use the command in VB like this.

If cCommand = ldDate then

When I try do the above, VB sees cCommand as a text. How can I get the
software to use the command inside of cCommand?

Without trying to use VBScript, the closest you'll get is by
storing snippets of SQL in your table, or perhaps by storing
rules in each field's and table's ValidationRule properties.

--
Joe Foster <mailto:jlfoster%40znet.com>  "Regged" again? <http://www.xenu.net/>
WARNING: I cannot be held responsible for the above        They're   coming  to
because  my cats have  apparently  learned to type.        take me away, ha ha!