No, you don't need to go as far as making extended stored procedures to call COM objects. You can use:
- sp_OACreate to create the object
- sp_OAMethod to call methods of the object
- sp_OAGetErrorInfo to get return values
- sp_OASetProperty to set properties
- sp_OAGetProperty to get properties
For more information, see SQL Server Books Online.