I guess I want to do something like this:

Set varTable1 = "tblCompanyNames"

Set VarTable2 = "tblCompanyNames2"

Set varPercentage = "10"

Set varDate = In VB this would be If Date = Monday, Friday,...

Yes - varTable1 and varTable2 are table variables.

I want to be able to set the table names outside of the INSERT statement.

I also want to be able to...