= VBA class module as MS-Office connector via XML-RPC

== Description

This plugin alloows you to use MS-Excel and MS-Project for ticket tracking of tickets which are logged and maintained in Trac.

There are following samples:
 1. [#MS-ExcelTicketeditor MS-Excel Ticket editor]: a hot-linked connection between your Trac tickets and your custom spreadsheet.
 2. [#MS-Projectconnector MS-Project connector]: a hot-linked connection between your Trac tickets and your MS-Project file.

== Bugs/Feature Requests

Existing bugs and feature requests for VisualBasicTracConnectorIntegration are 
[report:9?COMPONENT=VisualBasicTracConnectorIntegration here].

If you have any issues, create a 
[/newticket?component=VisualBasicTracConnectorIntegration new ticket].

[[TicketQuery(component=VisualBasicTracConnectorIntegration&group=type,format=progress)]]

== Download

Download the zipped source from [export:visualbasictracconnectorintegration here].

== Source

You can check out VisualBasicTracConnectorIntegration from [/svn/visualbasictracconnectorintegration here] using Subversion, or [source:visualbasictracconnectorintegration browse the source] with Trac.

== Installation

General instructions on installing Trac plugins can be found on the [TracPlugins#InstallingaTracplugin TracPlugins] page.

== Example

=== MS-Excel Ticket editor

 1. Fill setting sheet
 || [[Image(VBAExcel01.png, link=)]] ||

 2. Create sheets that are same name as project names
 || [[Image(VBAExcel02.png, link=)]] ||

 3. Push "Import tickets" button
 || [[Image(VBAExcel03.png, link=)]] ||

 4. Edit imported tickets' fields
 || [[Image(VBAExcel04.png, link=)]] ||

 5. Add new tickets
 || [[Image(VBAExcel05.png, link=)]] ||

 6. Push "Check modified fields" button

 7. Confirm the edited fields' background color are changed.
 || [[Image(VBAExcel07.png, link=)]] ||

 8. Push "Update" button

 9. According to the browser, modified tickets' fields are changed
 || [[Image(VBAExcel09.png, link=)]] ||

=== MS-Project connector

 1. Add custom fields.
||type ||name ||MS-Project's field || ||
||custom||due_assign ||Start ||required ||
||custom||due_close||Finish ||required||
||custom||complete||!PercentComplete ||required||
||custom||blocking||(dependency) ||add blocking ticket||
||standard||summary ||name || ||
||standard||owner ||resource || ||
||standard||milestone ||(dependency) ||Add preceding task for the milestone||
||standard||version ||(dependency) ||Add preceding task for the mversion||
||custom||summary_ticket||(summary task) ||Optional, for !TracDependencyPlugin ||
||custom||dependencies||(dependency) ||Optional, for !TracDependencyPlugin ||
||custom||baseline_start||!BaselineStart ||Optional ||
||custom||baseline_finish||!BaselineFinish ||Optional||
 2. Create tickets.
 3. Open TracProject.mpp 
  || [[Image(VBAPrj001.png, link=)]] ||

'''Note''': You may have to lower the macro security level in MS-Project for the connector's Import button to show up:

 * Choose Tools -> Options... to display the Options dialog.
 * Select the Security tab
 * Click the Macro Security button
 * Choose Medium or Low security

 4. Create blank mpp file. 
  || [[Image(VBAPrj002.png, link=)]] ||
 5. (Activate created mpp file.) It might be activated.
 6. Push "Import" button
  || [[Image(VBAPrj004.png, link=)]] ||
 7. input settings for your environment, then push "Validation" button
  || [[Image(VBAPrj02.png, link=)]] ||
 8. If connection is valid, then enable "Import" button. Push this button
  || [[Image(VBAPrj03.png, link=)]] ||
  || [[Image(VBAPrj04.png, link=)]] ||

== Recent Changes

[[ChangeLog(visualbasictracconnectorintegration, 3)]]

== Author/Contributors

'''Author:''' [wiki:okazaki] [[BR]]
'''Maintainer''': [[Maintainer]] [[BR]]
'''Contributors:'''