If anyone can help me with a problem i am having a problem with TDAPIOLELib
Basically i am trying to post bugs from an Excel spreadsheet if someone can give me a snippet of VB code ... i think to post you do bug.post
But how do you / where do you inherit bug from in the project ...
thanks so much
Re: TDAPIOLELib suggestions
Is there any reason why you wouldn't use the Excel add-in that you can download from the add-ins page?
Anyway, here are some basic starting code.
You retrieve bugs from the BugFactory object of the TDConnection object. It's also the object to use to add new bugs.
Dim TDC As New TDAPIOLELib.TDConnection
Dim bugFactory As TDAPIOLELib.bugFactory
Dim bug As TDAPIOLELib.bug
' Connect to Server
' Connect to Project
TDC.ConnectProjectEx Domain, Project, UserName, Password
' Get Bug Factory
Set bugFactory = TDC.bugFactory
' Create a new bug object
Set bug = bugFactory.AddItem(1)
' Populate bug fields from the Excel sheet
bug.field("BG_SUMMARY") = ActiveSheet.Cells(1,1).Value
' Add more bug.field("BG_...") = ActiveSheet...
' Post the bug object: it is then added to the back-end database
' and it receives an ID
' Disconnect from project
' Disconnect from server