Need VB Code using different api to find the defects

Asked By smadisonny 10 points N/A Posted on - 02/04/2013

I have been trying to develop a VB Code using different api to find the defects and import with specific filter criteria but I am unable to do that kindly suggest code for finding defect api for vba files ?

• Status: Open
• Question Views: 816
• Answer Count: 1
• Vote Up 1 Vote Down

• Answer Accepted: No
• Question Category: Visual basic

Answered By Berta R Cahill 30 points N/A #134970

Need VB Code using different api to find the defects

Hello there Samadisonny,

First of ll you need to know that VBA and API can be used to customize softwares according to your needs. These tools can be used to accomplish your task whether you want to build a quick VBA macro or a full-blown application based on our program’s object API.

Here is a demo code. I hope this may help you.

""""P

ROGRAMMING

B

ASICS

39

The following code sample shows filteri

ng accounts using th

e “Expenses” query:

Dim oQuery As CQueryObject

Set oQuery = New CQueryObject

oQuery.Init FE_Application.SessionContext

'This loads the query that is named Expenses.

oQuery.LoadByField uf_QUERY_NAME, "Expenses"

Dim oAccounts As CGLAccounts

Set oAccounts = New CGLAccounts

oAccounts.Init FE_Application.SessionContext

'This tells the collection which query (Expenses) to filter with.

oAccounts.FilterQueryID oQuery.Fields(QUERIES7_fld_QUERIESID)

'From here on, we can use the oAccounts collection and it will only

'contain CGLAccount objects that are in the Expenses query"""""

Here is a URL , you may look at this too

Hopefully I could help you.

Thank you

Berta R Cahill

 

About Berta R Cahill

Questions
71

Answers
15

Best Answers
6

• Vote Up 0 Vote Down

• Posted on - 03/20/2013
• Question Category: Visual basic