Jump to content

How to call method


Recommended Posts


I have this function to launch the application:

Public Function OpenApplication(exePath)
        SystemUtil.Run exePath

OpenApplication = 1
End Function

'Calling the function works.

url = "examplesite.com"

aa = OpenApplication(url)

'Instead of calling from the script, I would like to move the function and parameter in excel. So, in excel, I have two columns: method and parameter

My script goes to excel, read the method and parameter then make the call. I get type mismatch error at the last line myMethod(myParam).

	myMethod = SheetOne.Cells(2, 3)
	myParam = SheetOne.Cells(2, 4)

Please advise. 

Edited by newcoder1010
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...