Use VB script to run Excel macro

How to use Visual Basic Script to run Excel macro with single click. This technique can be use with Windows Task Scheduler to fully automate the process.
Follow us on

[IAMDRUIDS]

2 days looking for a working method for this, and this one worked perfect thanks very much!

[yacinejob]

perfect thanks, i advise to make a pause on the batch to get the errors if any

[TheTomar]

I couldn't tell what happen after you ran the run.bat youtube place some next videos at the end all over the screen.

[VQer]

Worked great, after a few tries. I managed to type the .xlsm file path wrong at first. By typing pause in a new line in the .bat file I was able to see my error after the file ran, and correct.

[MarkFreemanYVR]

Hey All - Here is the script.vbs code that can be copied and used.

Dim args, objExcel

Set objExcel =
Set args = wscript.Arguments

objExcel.Workbooks.Open args(O) ' Capital letter "O"
objExcel.visible = True

objExcel.Run "helloworld"

objExcel.ActiveWorkbook.Save

''wscript.sleep 5000 'sleep for 5sec 'this code can be used to pause and check the terminal window activity

' Capital letter "O"
ObjExcel.Quit

[valigeorge]

Thx for this tut. It works for me and it looks very fancy to me, specially when I set objExcel.Visible = False and everything happens in background. As I recommendation, you can use the PAUSE word in batch file to see if there is an error or if everything worked just fine. What I do not understand is the argument object. What we use that for? Thank you.

[isalovell]

Works perfectly! How can one add multiple Excel files in the same script?

[sabarirajan]

what if, the macro method in private ? will the method triggered from vbs ? kindly share your suggestion

[barrankobama]

running
cscript script.vbs "C:\Test\Book1.xlsm"
gives me
Microsoft VBScript runtime error: Wrong number of arguments or invalid property assignment

[AdamikPeter]

hello, Ive done exactly the same procedure but macro did not run. I mean run.bat is able to run script.vbs then this script is able to open excel, but it cant rund the macro. When i chceck the file I see the macro wasnt realized. Any idea?
thank you

[wirelad]

Hi - When I run this script / batch file from task scheduler - I see the dos window flash but the micro doesn't run? anybody ideas why? If I run the batch file manually, works fine. thanks

[gordonhorn]

Can you send/post the vbs script so that I can copy-paste? It's hard to tell if something is a zero or an O, or a comma or a period. Thank you!

[elshaymaanassar]

how to apply same macro to other xlsm sheet not owner to macro
or how to make macro public for many xlsm ?

[aninayan]

Thank You Very Much Sir, Its perfectly

[pratik]

I executed the macro by using only vbs but the GetOpenFileName pop-up called in macro is not coming on top of screen-which successfully comes when running the macro independent of the vbs---how to solve this issue?

[gustavfourie]

There is no search box on your website. Why dont you add the code here?

[ayaanansari]

Thanks Sir for this tutorial and also tell me know that how can exit .bat with the help of Script that Which is used to run script.vbs

[karinamartinez]

When I tried to run the VB script I got a Windows Script Host Error, Source: Microsoft VBScript runtime error (Code: 800A0009). Did anyone get the same error? Help, please!

[HartGekochteEierProj]

Would anyone know how to trigger the macro that is not part of the workbook but is being stored in Personal.xlsb folder?

[IrshadKhan-cfzu]

hello sir i need a vb scropt to find a value from excsl