Skip to content

Instantly share code, notes, and snippets.

@koara-local
koara-local / excel-clear-junk-style.vbs
Created April 28, 2017 02:18 — forked from hkuno9000/excel-clear-junk-style.vbs
[Excel]excelシートの書式をすべて削除するマクロ
Set objExcel = CreateObject("Excel.Application")
objExcel.Visible = True
For Each strFname In WScript.Arguments
Set objDoc = objExcel.Workbooks.Open(strFname)
' clear all names (comment out)
For Each N In objDoc.Names
'' N.Delete
Next
' clear all user style