search

mltefive / docs

https://mltefive.github.io/docs/
1 stars 0 forks source link

Sheets2xlsx.vbs #15

Open 7dir opened 4 years ago

7dir commented 4 years ago 
Set objExcel = CreateObject("Excel.Application")
Set objWorkbook = objExcel.Workbooks.Open("f:\ga\prjs\MCF_V2\EXPORT_G\MCF.xlsm")

objExcel.Application.Visible = False

objExcel.Application.Run "'f:\ga\prjs\MCF_V2\EXPORT_G\MCF.xlsm'!Module1.Splitbook"
objExcel.ActiveWorkbook.Close

objExcel.Application.Quit
WScript.Echo "Finished."
WScript.Quit
7dir commented 4 years ago

https://stackoverflow.com/questions/2050505/way-to-run-excel-macros-from-command-line-or-batch-file

7dir commented 4 years ago

https://stackoverflow.com/questions/37212135/download-automatically-spreadsheet-as-xlsx-to-local-machine-on-event

7dir commented 4 years ago

https://github.com/coldfusion39/inject-macro

7dir commented 4 years ago

Sub Auto_Open() Test End Sub

Public Function Test() As Variant MsgBox "This is a test Excel macro!" End Function