Excel macro needs to run a VB.NET application
Posted on 2003-03-10
I have a VB.NET application that generates an excel sheet and puts a macro button in the excel application that is generated. The data on the excel sheet is manipulated by the user. Once the data is updated (mainpulated) the user clicks the macro button that was generated by the VB.NET app. This button / macro needs to call another VB.NET app that updates the changed data on the Excel sheet to the Database. I am able to generate the excel macro button but do not know how to execute the VB.NET app from this button / macro. Does anyone have any code or alternate method to accomplish this.
Thanks a million