Hi,
I am new to VB and have a custom requirement as below,
1. Create a drop down list in excel and the values in the drop down list should be pulled from a table in SQL server database.
2. In the same Excel sheet, Create a Button, When clicked, that will call a store procedure from the small SQL server and use the value that is selected from the drop down as the Parameter for the store procedure and get the results in a new tab in the same excel sheet.
Please guide me how can i acheive this task.
Thanks
I am new to VB and have a custom requirement as below,
1. Create a drop down list in excel and the values in the drop down list should be pulled from a table in SQL server database.
2. In the same Excel sheet, Create a Button, When clicked, that will call a store procedure from the small SQL server and use the value that is selected from the drop down as the Parameter for the store procedure and get the results in a new tab in the same excel sheet.
Please guide me how can i acheive this task.
Thanks
