How to excute VBA script that ref from another module?

Help Studio
, ,
1

Hi, i have a VBA script like:

main.bas:

Option Explicit

Function TestCacCach()
    Dim ketQua As Double
    ketQua = utils.TinhTong(10, 5)  
    Debug.Print ketQua
    Dim tienFormat As String
    tienFormat =  utils.FormatTien(ketQua)
    MsgBox tienFormat
End Function

utils.bas :

Option Explicit

Public Function TinhTong(a As Double, b As Double) As Double
    TinhTong = a + b
    Debug.Print TinhTong
End Function

Public Function FormatTien(soTien As Double) As String
    FormatTien = Format(soTien, "#,##0") & " VNĐ"
End Function

How to excute TestCacCach from main.bas?

2

@Anonymous_iL

call macroname is what you need to sue to call scripts from another script

cheers

3

@Anonymous_iL,

You you don’t have access to the code of utils.bas, you will have to use Execute Macro activity on a xlsm file.

If you have access to the code, just copy both code in a text file and use Invoke VBA activity and pass the TestCacCach as Entry Method Name