Automate Excel to Solve Equations in Strings

Category:

Office/VBA

Type:

Classes

Difficulty:

Intermediate

Author:

Anonymous

Version Compatibility:

More information:

This is a class module that uses Excel as an evaluator of mathematical equations contained in strings. The code is well-commented and the comments include a good lesson on the advantages and disadvantages of using Excel automation, as well as how to setup a project that uses Excel automation for distribution.

Instructions: Click the link below to download the code. Select 'Save' from the IE popup dialog. Once downloaded, open the .zip file from your local drive using WinZip or a comparable program to view the contents.

Download excelcalculator.zip