Convert Excel Application to Visio 2010 or Stand-Alone App.

We need an existing Excel application converted to either a standalone application or integrated with Visio 2010. The application takes several user inputs and variables and calculates a two-dimensional contour rendering output for AutoCAD and then it is converted to Visio. We have access to the macros and Visual Basic components of the Excel file. We would like it to run within Visio 2010 and create the output in Visio 2010 or run as a stand-alone application that outputs to a Visio file. Our existing Excel application will not run on Excel 2010 and we would like to avoid opening the output in AutoCAD. We are open to suggestions if there is a better method that results in output to a Visio file that is editable (we can add or modify resulting file).