Convert VBA Code of Excel Macro to VB .net Excel Add on with COM abilities
- Status: Closed
- Prize: $10
- Entries Received: 3
- Winner: regzap
I have an Excel File connected to an external program using COM. I want to convert that code to VB .net as an excel add on. I attached the excel sheet. It is an easy task that can be finished with decent knowledge of programming.
Details of Task:
The excel file attached is connected to a program called PTV Visum by COM. What it does is, it read some input by user to excel then it get some data from VISUM. The coding I used for this is VBA. I want to convert it to VB .net as an excel add-on that reads the same input from an external excel file (like in PasteData sheet) then create new sheet and grab the values from VISUM.
The task can be done with Visual Studio. The code is needed later for further development.
“I liked working with Regza. He did exactly what was given to him. ”