Advertisement
Guest User

Untitled

a guest
Apr 27th, 2017
89
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.40 KB | None | 0 0
  1. Set objExcel = CreateObject("Excel.Application")
  2. objExcel.Visible = True
  3.  
  4. For Each strFname In WScript.Arguments
  5. Set objDoc = objExcel.Workbooks.Open(strFname)
  6. ' clear all names (comment out)
  7. For Each N In objDoc.Names
  8. '' N.Delete
  9. Next
  10. ' clear all user style
  11. For Each S In objDoc.Styles
  12. If Not S.BuiltIn Then
  13. S.Delete
  14. End If
  15. Next
  16. objDoc.Save
  17. objDoc.Close
  18. Set objDoc = Nothing
  19. Next
  20.  
  21. objExcel.Quit
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement