Website Upgrade Incoming - we're working on a new look (and speed!) standby while we deliver the project

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

S Curves

14 replies [Last post]
Thu, 2007-03-15 05:17
Mark Chapman
User offline. Last seen 8 years 50 weeks ago. Offline
Joined: 18 May 2006
Posts: 183
Groups: None
How do I transfer my EV costs into an S-Curve within MSP 2003?
Top

Replies

Thu, 2007-03-29 22:04
#1
Rodel Marasigan
User offline. Last seen 2 weeks 6 days ago. Offline
Joined: 25 Oct 2006
Posts: 1699
Groups: Petro-Chem / Oil & Gas
Masoud,

I’m writing a VB code to import MSP data to excel and half way through I realized that it needs to do a calculation inside the VB in order to get the % completed on the range date required per hrs, week or month depending on your selection. It will take sometimes to do that in order to get the right formula running when you change the range. I went back to your query and thinking that you only need the code to run “Analyze Timescaled data in Excel”. If that’s the case all you need is a very simple code to include on your current macro.

Try to insert this code and let me know if this help.

Application.CommandBars("Analysis").Visible = True
SendKeys ("%y")

Regards,
Rodel
Top
Thu, 2007-03-29 17:28
#2
Rodel Marasigan
User offline. Last seen 2 weeks 6 days ago. Offline
Joined: 25 Oct 2006
Posts: 1699
Groups: Petro-Chem / Oil & Gas
Masoud,

Simple answer is no because it is add-in program or we call it external program. I’m trying to write a visual basic code for your requirement.

Regards,
Rodel
Top
Thu, 2007-03-29 07:56
#3
masoud rahimian
User offline. Last seen 15 years 42 weeks ago. Offline
Joined: 16 Aug 2004
Posts: 13
Groups: None
hi Alexandre
check it to see that MSP records no thing about this action.
is there any was instead?

yours truly
masoud
Top
Thu, 2007-03-29 04:39
#4
masoud rahimian
User offline. Last seen 15 years 42 weeks ago. Offline
Joined: 16 Aug 2004
Posts: 13
Groups: None
Hi Rodel
i need to plot S-Curve of a project
currently:I use "Analysis time scaled data in excel" button to export %complete of my tasks,then with some correction of round up bug in exported data in excel,i have %complete of each activity & summery in excel.

now the problem is:
i need to export these data to excel automatically from within the VBA code.by the other word, i need to fire this button from inside the VBA code.

sincerely
masoud
Top
Wed, 2007-03-28 16:21
#5
Rodel Marasigan
User offline. Last seen 2 weeks 6 days ago. Offline
Joined: 25 Oct 2006
Posts: 1699
Groups: Petro-Chem / Oil & Gas
Sorry Masoud,

I don’t quite understand your query. Can you explain it a bit detail and gave me an example so I can help you further?
Do you want a pop up form to gave you the % complete or export it to excel spreadsheet?

Rodel
Top
Wed, 2007-03-28 00:35
#6
Rodel Marasigan
User offline. Last seen 2 weeks 6 days ago. Offline
Joined: 25 Oct 2006
Posts: 1699
Groups: Petro-Chem / Oil & Gas
Hi masoud,

Im not sure how good are you in writing Visual Basic in MSP. I assumed that you are familiar on this command. You can check this sample and use as a guide.

MapEdit Name:="Map 1", Create:=True, OverwriteExisting:=True, DataCategory:=0, CategoryEnabled:=True, TableName:="Task_Table1", FieldName:="ID", ExternalFieldName:="ID", ExportFilter:="All Tasks", ImportMethod:=0, HeaderRow:=True, AssignmentData:=False, TextDelimiter:=Chr$(9), TextFileOrigin:=0, UseHtmlTemplate:=False, TemplateFile:="C:\Program Files\Microsoft Office\Templates\1033\Microsoft Project Web\Centered Mist Dark.html", IncludeImage:=False
MapEdit Name:="Map 1", DataCategory:=0, FieldName:="Name", ExternalFieldName:="Name"
MapEdit Name:="Map 1", DataCategory:=0, FieldName:="Early Start", ExternalFieldName:="Early_Start"
MapEdit Name:="Map 1", DataCategory:=0, FieldName:="Early Finish", ExternalFieldName:="Early_Finish"
MapEdit Name:="Map 1", DataCategory:=0, FieldName:="Duration", ExternalFieldName:="Duration"
FileSaveAs Name:="C:\sample2.xls", FormatID:="MSProject.XLS5", map:="Map 1"

This samples export ID, Name, ES, EF and duration to sample2.xls. I’m not sure what data you required or need to extract in Task_Table.

HTH
Rodel
Top
Wed, 2007-03-28 08:27
#7
masoud rahimian
User offline. Last seen 15 years 42 weeks ago. Offline
Joined: 16 Aug 2004
Posts: 13
Groups: None
hi
thanks a lot for your code snippet.I am familiar with many of MSP object model methods such as UPDATEPROJECT method or EDITCOPY method,but there is not any standard msp method that work like pressing "Analysis time scaled data in excel" button in msp environment.

by another word,is there any method to find out %complete of a rescheduled and/or splited task?

i want to find it from inside of vba method in daily basis

regardes
masoud
Top
Tue, 2007-03-27 12:57
#8
masoud rahimian
User offline. Last seen 15 years 42 weeks ago. Offline
Joined: 16 Aug 2004
Posts: 13
Groups: None
dear Alexandre Faulx-Briole
i think,i must described the problem:
i want to exporting the values to excel and do something, faster and automated.
i can write some macros and OLE to msp to do some thing like adding tasks automatically.now, i want to export these data automatically

best wishes
masoud
Top
Tue, 2007-03-27 12:16
#9
masoud rahimian
User offline. Last seen 15 years 42 weeks ago. Offline
Joined: 16 Aug 2004
Posts: 13
Groups: None
Hi

is there any way to call"analysis in excel" button from inside a VB program.i need to automate the senario.

regards
masoud
Top
Fri, 2007-03-16 02:15
#10
James Griffiths
User offline. Last seen 16 years 3 weeks ago. Offline
Joined: 19 May 2006
Posts: 435
Groups: None
Mark,

Use the ANALYSIS toolbar. It’s quite simple.

James.
Top
Thu, 2007-03-15 05:25
#11
Brad Lord
User offline. Last seen 10 years 34 weeks ago. Offline
Joined: 27 May 2003
Posts: 256
Groups: None
hi mark

give me a call 07929 642107 and i will talk you through it hate explaing things by email/text

regards

brad
Top