Hi guys,

Just to let you know where I'm at, I've been following this blog up to the formula stage (http://siddharthrout.wordpress.com/vb-net-and-excel/)

Right here's where my problems start;

I'm looking to use the Excel integration with VB Form to perform calculations.

1. Front end user will enter data into boxes in the VB Form.
2. Front end user will press the create button.
3. This will use the data values in the VB form text boxes combined with excel formulas and create an Excel file with the results.
4. The user can then save this data externally or internally using Access button on VB application.