Invoke Code is strictly for VB.NET code.
VBA runs on an Excel workbook. If you absolutely have to run VBA code on a workbook, it either needs to have that code in a Sub inside that workbook, or you can make an empty workbook and pack that code in it (adding enough code to open and close that other workbook)
3 Likes