In javascript I could concatenate strings and then execute the result as a
single command using the EVAL() function. I'd like to be able to do the same
in excel, but have yet to find a way of doing so. Compatibility with Excel 97
is not necessary, only 2000 onwards.

Does anybody here have a way of acheiving this?

You can use the EVALUATE (Application.Evaluate or Worksheet.Evaluate)
method, but this executes strings as Excel formulae rather than VBA
statements.

MsAccess has an EVAL function which will interpret VBA strings, but there is
no exact equivalent in Excel.

"PatrickS" <msdn_newsgroups001@_removetextplusunderscores_seu rre.com. wrote
in message ...
In javascript I could concatenate strings and then execute the result as a
single command using the EVAL() function. I'd like to be able to do the
same
in excel, but have yet to find a way of doing so. Compatibility with Excel
97
is not necessary, only 2000 onwards.

Does anybody here have a way of acheiving this?