P
Pete
I have a number of reports that are exported to Excel and then turned into
pivot tables or reformatted, using Excel automation. I would like to avoid
hard coding the Excel automation code into my reporting screen, instead
holding it in a memo field so that the process is data-driven and if, for
example, the formatting requirement changes, I just need to modify the script
in this field, rather than issue a new version of my database.
I can read in this data as a string, but I am unable to get it to execute.
Is there a function similar to Eval that can be used for this puropse?
Thanks in anticipation
pivot tables or reformatted, using Excel automation. I would like to avoid
hard coding the Excel automation code into my reporting screen, instead
holding it in a memo field so that the process is data-driven and if, for
example, the formatting requirement changes, I just need to modify the script
in this field, rather than issue a new version of my database.
I can read in this data as a string, but I am unable to get it to execute.
Is there a function similar to Eval that can be used for this puropse?
Thanks in anticipation