Learn Invoke VBA Excel Automation

1 Like

Step1. Copy the macro code in Excel and create a new file with “.bas” extension.
Step2. Using “Invoke VBA” and specify the file path and method name like below.


  1. Please put the “Invoke VBA” inside Excel Application Scope.
  2. Using the properly method name.
    exec2_実行 >> NG
    tyfunction >> OK
  3. Please do not using the same method name with excel file’s method