I have never attempted this, but take a look at:

Use a shared workbook to collaborate

First figure out how to make this work through the Excel interface and take notes. Now you can begin to figure out how to automate that via Excel interop using your VB program.