Kiro,
I'm afraid several weeks isn't really enough time to scratch the surface of creating an entire user interface for a project portfolio application - unless your requirements are very very very very basic.
One thing I suppose you could do is automatically or manually generate some static HTML for each of your views and give folks a way to navigate from one to the other. Colored backgrounds are clearly do-able with HTML - although I'm not sure why that is such an important requirement. Why don't you look into creating some HTML pages and see how they work for you. If they look OK and you have a little HTML skill you could go that route.
The automation of generating the HTML pages is fairly straightforward. Something like this:
Sub Save2HTML(Optional strNewHTMLFilename As String = "NewHTMLFile.html")
' this procedure takes one optional string argument for the new HTML filename
' if the argument is left blank the new filename will be "NewHTMLFile.html"
'
' most of the MapEdit stuff just creates a mapping for the data export so you
' know which fields are going to be called what in the HTML output
'
' the first MapEdit line creates the export map, gives it a name of "Map 1"
' and tells the map what to export when the HTML is created.
'
' YOU SHOULD ADD ERROR TRAPPING TO THIS CODE
' ERROR TRAPPING EXCLUDED TO ENHANCE READABILITY
MapEdit Name:="Map 1", Create:=True, OverwriteExisting:=True, DataCategory:=0, CategoryEnabled:=True, TableName:="Entry", FieldName:="ID", ExternalFieldName:="ID", ExportFilter:="All Tasks", ImportMethod:=0, HeaderRow:=True, AssignmentData:=False, TextDelimiter:=Chr$(9), TextFileOrigin:=0, UseHtmlTemplate:=False, IncludeImage:=False
MapEdit Name:="Map 1", DataCategory:=0, FieldName:="Name", ExternalFieldName:="Task Name"
MapEdit Name:="Map 1", DataCategory:=0, FieldName:="Duration", ExternalFieldName:="Duration"
MapEdit Name:="Map 1", DataCategory:=0, FieldName:="Start", ExternalFieldName:="Start"
MapEdit Name:="Map 1", DataCategory:=0, FieldName:="Finish", ExternalFieldName:="Finish"
MapEdit Name:="Map 1", DataCategory:=0, FieldName:="% Complete", ExternalFieldName:="% Complete"
MapEdit Name:="Map 1", DataCategory:=0, FieldName:="Cost", ExternalFieldName:="Cost"
MapEdit Name:="Map 1", DataCategory:=0, FieldName:="Work", ExternalFieldName:="Work"
Application.FileSaveAs Name:=strNewHTMLFilename, FormatID:="MSProject.HTML", map:="Map 1"
End Sub
Sub SaveHTML()
Call Save2HTML
End Sub
Copy and paste this code into a module in project and you can run SaveHTML from the macros list - AltF8. Save2HTML won't appear in the macros list because it takes an argument and there's no way to pass the argument from that screen. When you're ready to take the next steps you'd need to pass in the filenames you want at runtime - which can be done with SaveHTML by simply slapping a filename string on the end of that call - like this:
Sub SaveHTML()
Call Save2HTML "MyReallyCoolProject.html"
End Sub
Hope that helps.
Earl
My main purpose of the Interface is so people can use the Projects iv
interlinked more easily....by using macro buttons to navigate round, rather
than use MS Projects menu systems.
I was also hoping to be able to add coloured background some how....as I
know you can't easily or I don't know how with MS Project.
Basically I want to make my custom "Interface" by someone helping me write
the code (if that way is possible) for what im asking or point me in the
right direction of software I can link to MS Project to get my desired effect
??
My time constraints for this is in weeks :|
Hope that gives you the details required to assist me...thank you for your
time im very grateful
