Automating Excel to remove VB Code.

  • Thread starter Thread starter Steve Ramsden
  • Start date Start date
S

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.
 
Back
Top