Search code examples
excelautoitvba

How open the AutoIt script from excel workbook and after that parent Workbook get close?

In my current project, Excel macro open AutoIt script using a function Call Shell("location of autoit script").

For proper functioning of AutoIt script it's need to be close parent Excel workbook, so this closing Excel action is written in AutoIt script itself.

But as soon as AutoIt script close parent Excel workbook then script get pause and it do nothing.

How open the AutoIt script from Excel workbook and after that parent Workbook get close?

Solution

  • This problem can solve with open the AutoIT script first and then open Excel file using AutoIT script, after that AutoIT close itself and still Excel is open.