I am trying to run Excels Solver add-in via pywin32 in python with:
import win32com.client
from win32com.client import constants as c
app = Dispatch("Excel.Application")
app.Visible = True
app.Workbooks.Open(r'C:\path\to\testsolver.xlsm')
app.Run("runsolver")
..but get the following error:
"Cannot run the macro 'runsolver'. The macro may not be available in this workbook or all macros may be disabled"
I realise this is a year old, but in case this is still of value the problem here may be that Solver is not automatically loaded when an Excel OLE object is created. By design, add-ins must be loaded manually before they can be used in an Excel OLE object.
You can confirm that it isn't loaded by examing the OLE created instance and going to the "Data" tab and observing that Solver doesn't appear there, like it does when you open Excel from the Windows GUI.
I discovered this while trying to solve a similar problem in Delphi code as described here:
I expect the Python syntax will be similar.
