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.
image

Note:

  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