Automating Excel to remove VB Code.

[Steve Ramsden]

Hi,

I have an Excel worksheet which is automated via MS Access. The Excel sheet
contains some code of its own which is invoked by Access. What I want to be
able to do is 'tidy up' the Excel sheet when all the code has finished
execution , so that all the code is removed. Can I do this via automation?
I cannot find the correct syntax to do this, though I suspect it may have
something to do with the 'VBProject' class.

Any ideas?
TIA
Steve.