Excel Custom Functions
Convert spreadsheet calculations to user-defined functions, without coding.
No need to learn VBA or C++
Replace blocks of cells with a single call to the new custom function.
No more copying and pasting and getting your absolute and relative references wrong
Make Excel spreadsheets work inside other systems instantly
Calc4Web automatically turns spreadsheets into C++ programs that integrate into other systems. Even turn spreadsheets into Web Services.
How Calc4Web Works
Calc4Web converts Excel spreadsheets to C++ functions, and then compiles that into a DLL that can be called from other programs.
It also creates an XLL, or Excel addin, which allows the function to be called from another Excel spreadsheet. Calc4Web also creates several other applications which use the generated function, including a standalone application (which consists of a dialog box that prompts for function inputs and displays the function results), a Web page which contains a form that prompts for function inputs and displays the function results, a sample C++ application, a sample Visual Basic application, header files, and a Web Service.How To Use Calc4Web
Spreadsheets are often used to calculate results based on a set of inputs. Although database tables, charting, macros and input forms may also exist in the spreadsheet, the portion of the workbook that Calc4Web operates on are those cells that are used for calculations.
IIn these types of spreadsheets, there are always one or more cells which drive the calculation (Cal4Web refes to these as input cells), and one or more cells that contain the results of thecalculations (the output cells).To use Calc4Web, simply tell it:
- which cells are input cells, and what types they are (text, numbers, ranges)
- which cells are output cells, and what types they are
- what name to give to the function and the DLL it is going to generate
For example, let's suppose we want to create a function to add two numbers together. The spreadsheet may look like this:
Cells A1 and B1 are the input cells, and C1 contans the result. Tell Calc4Web about the new function in this input screen:
That's it! After clicking on the Calc4Web Builder button on the Excel toolbar, the new MyAdd function will be created, and can then be used inside other programs, including other Excel spreadsheets:
This was a simple example; Calc4Web can handle much larger spreadsheets, with many more formulas than this. And any of Excel's built-in functions, like SUM, AVERAGE, and IRR, can be used in the spreadsheet and converted to C++ code by Calc4Web.
If you'd like to try out Calc4Web, simply fill out the form above to immediately receive your copy.
Calc4Web comes with a 30 day money back guarantee, no questions asked.
| "Once you’ve used Calc2Code, you may find that you simply can’t be without it." Rick Grehan, InfoWorld "It's not just cool. It's simple." Tom Yager, InfoWorld "With Calc2Code, I'm able to write sophisticated C++ programs in minutes using only an Excel spreadsheet. Doing it directly in C++ would take several days." Jerome Montpetit, Risk Manager, Canadian Financial Institution "A highly specialized tool that can bring significant benefits to some development tasks." Peter Aitken, DevSource "Calc2Code does just one thing: converts Excel spreadsheets and VBA to C++ DLLs and addins. But the implications of this, and it's myriad uses, are much more far-reaching in terms of latency reduction and productivity enhancement." Andy Webb, e-FOREX |