Eval function without the morefunc add-in

rajat_magic

Board Regular
Joined
Sep 22, 2003
Messages
57
I have used the EVAL function in my spreadsheet. However, I will need to send this file to a number of people who probably don't have this add-in installed. Is there someway I can use this function without making it necessary for the user to have this add-in?

Thanks.
 

Some videos you may like

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,192
rajat_magic said:
I have used the EVAL function in my spreadsheet. However, I will need to send this file to a number of people who probably don't have this add-in installed. Is there someway I can use this function without making it necessary for the user to have this add-in?

Thanks.

You can invoke the following udf in VBA instead, which you need to add to your workbook as a module:

Function Eval(Ref As String)
Application.Volatile
Eval = Evaluate(Ref)
End Function
 

tusharm

MrExcel MVP
Joined
May 28, 2002
Messages
11,007
Do keep in mind that access to the EVAL function was intentionally removed by MS as a major security risk. Are you sure you want to reinstate access for anyone who opens your workbook?
rajat_magic said:
I have used the EVAL function in my spreadsheet. However, I will need to send this file to a number of people who probably don't have this add-in installed. Is there someway I can use this function without making it necessary for the user to have this add-in?

Thanks.
 

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,192
tusharm said:
Do keep in mind that access to the EVAL function was intentionally removed by MS as a major security risk. Are you sure you want to reinstate access for anyone who opens your workbook?
rajat_magic said:
I have used the EVAL function in my spreadsheet. However, I will need to send this file to a number of people who probably don't have this add-in installed. Is there someway I can use this function without making it necessary for the user to have this add-in?

Thanks.

You need to elaborate this and also state whether it equally involves EVAL of the morefunc add-in. As far as I know, EVAL in Lisp is never considered a security risk, for example.
 

rajat_magic

Board Regular
Joined
Sep 22, 2003
Messages
57
Thanks guys. I also figured that if its available in VBA, it might be possible to define it as a name as well. Tried it, and its working...

Does anyone have any background on what kind of security risks this may lead to, and in what conditions? Thanks.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,642
Messages
5,524,042
Members
409,556
Latest member
gimbox16

This Week's Hot Topics

Top