Hi
i am not familiar in logic please anyone can help me to give sugesstion
my problem is I have a keyword product portfolio list and done export individual but our client asked me in that list they said All say example : in the list we have east west north south now they are asking east west together
and aswell as individual so i updated a productportfolio keyword doc with name “ProductEW” and ProductNS so in this issue anyone can help i really appreciate
for idiea i am given below details
Set doc = vwKW.GetDocumentByKey( “ProductPortfolioList” )
vPList = Evaluate( doc.keyword_values(0) )
vSelect = workspace.prompt(5, "Select a Project/Portfolio", "Select a Project/Portfolio for this report", "", vPList )
If Isempty (vSelect) Then
Exit Sub
End If
'“Help needed (Please in put your suggesstions below”
'set objects
currentprocess = "setting objects"
’ Set uiview = workspace.CurrentView
’
’ Set view = uiview.View
’ Set viewnav = view.CreateViewNav()
Set doc = vwKW.GetDocumentByKey( "ProductPortfolio" )
If doc Is Nothing Then
Messagebox "The Export Template is missing. Report this to the help desk.", 0, "Cannot Export"
Exit Sub
End If
'/***********************************
' *
' * This section covers the Excel template
' * and the categories for exporting and sorting
' *
' * The categories can be expanded/shrunk
' * by modifying the keyword Values field
' *
' *************************************/
StatusList = Evaluate( doc.keyword_values(0) )
'StatusList = Evaluate( {"Funded":"Approved":"Prioritized":"Open":"Cancelled":"Completed"} )
vMyDocuments = Evaluate( {@RegQueryValue("HKEY_CURRENT_USER"; "Software\\Microsoft\\Windows\\CurrentVersion\\Explorer\\Shell Folders"; "Personal")} )
’ Messagebox vMyDocuments(0)
Stop
'get user selection
'extract TEMPLATE from KEYWORDS