o see examples of Python-VBA interaction look at the implementation of the
functions pfeEval and pfeCmd in the VBA code for otsPythonForExcel.xla(m). Do
not, however, explicitly open that addin. It would lead to repeated
initialization and will corrupt the namespace. If the PFE is properly
installed then the PFE addin should be already loaded into every open Excel
instance. Simply open a VBA window and look at the otsPythonForExcel.xla(m)
code.
|
