Hi there,

I have a strange requirement. I am not sure if it is feasible. I would be
very greatful if someone could provide a solution for this problem.

I have to generate a file. This file would have a "command" or "code" in the
first cell A1. When the user opens the file, the "Auto_Open" macro within
the file would check this code and expand it as required.

Now the problem is that, the file has to be editable by another program,
which would modify the cell A1 and insert the correct code. But this program
could work only with text files.

I am aware that excel can process XML, CSV files (which are text file) and
read in the data.

My question is, is it somehow possible to include macros in XML file ? Or is
there a better way to acheive this ?


Thanks a lot in advance.