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

Advertiser Disclosure: Some of the products that appear on this site are from companies from which QuinStreet receives compensation. This compensation may impact how and where products appear on this site including, for example, the order in which they appear. QuinStreet does not include all companies or all types of products available in the marketplace.