Dim excl
Set excl = CreateObject("Excel.Application")
excl.Visible = False
excl.Workbooks.Open "path of excel file"
excl.Run "macroToExecute"
excl.Quit
をhoge.vbsとかで保存して、fuga.batに
cscript hoge.vbs
とかって書く。
More than 5 years have passed since last update.
Dim excl
Set excl = CreateObject("Excel.Application")
excl.Visible = False
excl.Workbooks.Open "path of excel file"
excl.Run "macroToExecute"
excl.Quit
をhoge.vbsとかで保存して、fuga.batに
cscript hoge.vbs
とかって書く。
Register as a new user and use Qiita more conveniently