How to execute vba from vbscript

Question

I search answers on this site , but they do not have complete info

I have a file c: ....test.xlsm it has a subroutine test ()

sub test () 
msgbox "hello stackoverflow"
end sub

I want to write a vbscript that would

1) open c: ....test.xlsm

2) run test () subroutine

3) close c: ....test.xlsm

How can I do this ?

Sorceri · Accepted Answer · 2014-03-31 23:08:38Z

1

Assuming it is in a module, you would call it like so

dim eApp
set eApp = GetObject("C:\wb.xlsm")
eApp.Application.Run "wb.xlsm!test"
set eApp = nothing

answered Mar 31, 2014 at 23:08

Sorceri

8,0932 gold badges32 silver badges40 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1