Generally running stored procedures on the linked server is the PREFERRED method over direct queries as recommended by Microsoft Corporation.
If you think of it, that makes sense. Your server is a client to the linked server.
Same principal when the client is a VB, sprocs are the best not direct queries.
Another advantage: if network outage occurs, the transacation completes without hanging.