home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
On Hand
/
On_Hand_From_Softbank_1994_Release_2_Disc_2_1994.iso
/
00003
/
s
/
main.fr$
/
main.bin
(
.txt
)
Wrap
Visual Basic Form
|
1993-01-01
|
12KB
|
350 lines
Analyzer
wwwww
wp|||
wwp|||
wwwp|||
wwwwwwww
Form1%
GrayBackground
ListTitle
"Slipped Tasks (by Finish Variance)
Title
!Task Most Behind Planned Schedule
Problem
Problem1
AllProblems
AllProblems1
GrayBackground
ListTitle
%Overcost Resources (by Cost Variance)
Title
Resource Most Over Planned Cost
Problem
Problem2
AllProblems
AllProblems2
GrayBackground
ListTitle
'Overworked Resources (by Work Variance)
Title
Resource Most Over Planned Work
Problem
Problem3
AllProblems
AllProblems3
ShowList
More...
ShowList
More...
ShowList
More...
ActiveProject
ActiveProject
WINPROJ|System
ActiveProject
NewViewFile
NewViewFile
WINPROJ|System
ViewFile
ActiveView
ActiveView
WINPROJ|System
ActiveView
ActiveTable
ActiveTable
WINPROJ|System
ActiveTable
ActiveFilter
ActiveFilter
WINPROJ|System
ActiveFilter
ViewFile
ViewFile
WINPROJ|System
ViewFile
FileMenu
&File
FileChange
Change &Project...
FileUpdate
&Update Information
FileExit
E&xit
&Help
L HelpAbout
&About Analyzer...
Command1_Click
Label1_Click
Picture1_Click
Form_Click[
Index
Picture3_Click^
Pictur
Clicku
Picture1
cture1'
sendz
sendPicture1
Label1_DblClick~
ShowMoreInfoK
Picture1_DblClick
asfsgW
Problem1_Click
Problem1_DblClick@
Form_Paint
Form_MouseDown
Button
Shift!
ProblemNum
Label2_Click
Label2_DblClick
Label3_Click
Label3_DblClick
Problem2_Click$
Problem2_DblClick6
Problem3_Click
Problem3_DblClick
Picture2_Click
Update_Click-
Problem1
LinkMode+
LinkTopic
LinkItem
Problem2B
Linb!
Problem3x
Update/
Enable
FALSE
Enabled]
Form_Resize
minimU
FALSEEnd:
DblClick
Listt
Problem1_Update0
CaptionR
SysInfo1
PROJNAME
GrayBackground_Click7
GrayBackground_DblClick
Problem_Click
Problem_DblClick
Title_Click
Title_DblClicke
Problem
Get_Which_Projectm
Slipping2
DDECmd
AllProblems
Problemsi
FirstN
CRPosition
TabPosition
Done_Click
About_Click>
AboutBox
Problem2_Update
Linkequest
Problem3_Update
MORE_INFO_ON
NewDoc_Click
Topics
Form_LoadO
Valuee
AllProblems_Click
FormatSort
Key1l
Descending1
Problem_LinkError
LinkErr
LinkError
TempLink
syntax_error
ACTIVE_VIEW
ACTIVE_PROJECT
ACTIVE_TABLE
CalendarFile
ViewFileZ
ActiveView
ActiveTable
ActiveFilter
NewViewFileP
Form_LinkError
foanalyzer
DOWN:
CriticalTasks
DDERequest
channel2
channel1C
Insert
Project
SlippedTasksh
ActiveFilter_ClickN
ErrorHandling
OvercostRes
OverworkResD
ErrorHandling2
ErrorHandling1`
ErrorHandling3m
ErrStr
ShowList_Clickr
FileExit_Click
FileChange_Click
FileUpdate_Click
FileUpdateq
ShowList&
HelpAbout_Click
Screen
Width
Heighti
IDListOf
CommaPosC
TabPos2
TabPos1a
TabPos
CRPos2
CRPos1
ARGUMENT
REPLACE
ExFile_Path
ExFile_PathChar
ISERR
ExFile_Replace
ExFile_Done
Filename
ListTitle_Click
COLDProblem
ProblemViewR
ProblemFilter
ProblemSort
FileMenu_Click
Problem_Update
ProblemReq1
ProblemReq2
ProbErrorHandling
ActiveTable_Click
ActiveView_Click
Help_Click
NewViewFile_Click
Null_Click
ViewFile_Click
Get_Info_From_MSProject
ActiveProject
SetListSeparator
RestoreListSeparator
ShowList_Click
FileChange_Click
FileExit_Click
FileUpdate_Click
HelpAbout_Click
IDListOf
Takes a DDE selection description string from Microsoft Project, such asn
"T((1,2,4),(Name,Duration))" and returns the ID or list of IDs in the
description as a string, such as "(1,2,4)""
Problem_Update
This subroutine goes to Microsoft Project and gets the data specified
ProblemXxx$() array.
To change the data grabbed from MS Project, change the strings in the
Get_Info_From_MSProject subroutine for this form.
Apply the Work Overbudget filter and sort by work variancey
WINPROJ|System
Link to System topic(
for executes and selectionS
Get the list of sorted tasks or resources
SelectAll"
Select the sorted resources
NumLines
Request the number of lines
in the selectiont
If there aren't any,f
tell the user and
disable More... button
Otherwise...
Selection"
Request the description
of the selectiont
Parse out the ID's and form request string to get names and variances
Terminate link to change topict
WINPROJ|
Link to project topic
Enable More... button
Get_Info_From_MSProject
Load ProblemXxx$(3) arrays with correct DDE execute statements
and task/resource field numbers
Note this expects the presence of some views and filters whichw
are included in the default view file. If they are not present,s
the user will get a rather ungraceful alert. The best way to
avoid this would be to use the Microsoft Project ViewFileOpen
command.m
View [Task Sheet]"
Filter Slipping"
FormatSort [Finish Variance] .Ascending1=No"
Task fields...n
,(67,1))
...67=Finish Variance, 1=Name
View [Resource Sheet]"
Filter [Cost Overbudget]
FormatSort [Cost Variance] .Ascending1=No"
Resource fields...
,(34,1))
...34=Cost Variance, 1=Name
View [Resource Sheet]"
Filter [Work Overbudget]
FormatSort [Work Variance] .Ascending1=No"
Resource fields...a
,(25,1))
...25=Work Variance, 1=Name
Prepare for LinkRequest
Center form on screen
Set the name of the form to reflect the analyzed project,
without the path informationr
Analyzer - "
Close to a single pane and remember which view file was open,
which view, table, and filter were applied and which projecti
was active. PaneClose ensures we will be in a master panec
so filters can be applied.t
View file before analysis
PaneClose"
View file after analysiss
View
before analysisi
Table
Filter
Project
Request information to analyze from correct project
WindowActivate .WindowName="
Reset the original view information in Microsoft Projectj
FileOpen "
View [
Table ["
Filter [
Form_Load
SetListSeparator
Copy the list separator character from Microsoft Project,
and replace it with a comma. This is necessary so that
LinkRequest statements will be understood by MS Project.j
This subroutine should be called before any LinkRequestsu
are performed, and should always be paired with a subsequentq
call to RestoreListSeparator.
No Clipboard operations should be made between these twoe
calls, since the list separator is held there.
WINPROJ|System
AppExecute
Prepare MS Project to accept SendKeys
{F10}op{PGDN 4}{F2}{HOME}+{RIGHT}^c{ESCAPE 2}"
AppMinimize"
Minimize Microsoft ProjectP
OptionsPreferences .ListSeparator=[,]"
RestoreListSeparator
Restore the list separator character in Microsoft Project
from the Clipboard. SetListSeparator should be called before
calling RestoreListSeparator.
See SetListSeparator for more information.t
WINPROJ|System
AppExecute
Prepare MS Project to accept SendKeys
{F10}op{PGDN 4}{F2}{HOME}+{RIGHT}^v{ENTER 2}
AppMinimize"
Minimize Microsoft Project