ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Excel equivalent to Eval function (https://www.excelbanter.com/excel-programming/395526-excel-equivalent-eval-function.html)

PatrickS

Excel equivalent to Eval function
 
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?

Charles Williams

Excel equivalent to Eval function
 
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?





All times are GMT +1. The time now is 05:21 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com