![]() |
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? |
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