View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Trev B Trev B is offline
external usenet poster
 
Posts: 15
Default Delete a sheet and delete a module in Another Worksheet then save

Hi,

Thanks in advance.

My problem is that i need VBA code to open 6 xls files (In turn) and to each
of them:

1) Delete a sheet called "Prog"

2) Delete a module called "modActions"

3) Save the file

Thanks very much for your attention.
Regards

Trev B