Hi,
I'm trying to replace VBA with Mathematica in Excel spreadsheets.
I understand that Excel-Link is the right tool, but reading the documentation on the Wolfram website it seems that the product is not compatible with 64-bit Excel.
"Mathematica Link for Excel 3.7.1 requires Mathematica 8 or greater and Microsoft Excel 2010 or newer. It is available for Windows 7, 8, 8.1 or 10. Earlier software and operating systems may be supported with a few limitations. ***The ExcelLink package for Mathematica is compatible with both 32-bit and 64-bit versions of Mathematica and Excel. The Mathematica Link add-in for Excel is compatible only with the 32-bit version of Excel***. "
My platform is a 64bit Windows Server 2016 with a 64bit Excel, this means that I can use ExcelLink package to drive Excel/64bit from a Mathematica-notebook but I can not create mathematica-macros cause the 32/64 bit incompatibility.
Can someone using Excel-Link help me better understand the situation?
Thank you so much for your collaboration
Massimo