Automate Milestone Text Attribute Changes
Fri, 21 Sep 2007 15:38:49 -0700
I'm looking to change the text attributes for milestones so that they
stand out in MS Project 2007. Is there a way to create a macro that
will change the color, make it bold and italicized if the duration is
equal to 0?
If not duration then some other variable that I can set and run a
macro against.
Thank ...
|
Professional Excel Development Chapter 5
Fri, 21 Sep 2007 12:46:04 -0700
I am fairly new to excel vba so forgive me if these are stupid questions.
Excel VBA 2003
1st
what exactly does this mean (more specifically the part starting with
rngName.Value, "=" & rngSetting.Value)
wksSheet.Names.Add rngName.Value, _
"=" & rngSetting.Value
(see code be ...
|
languageID?? FileOpen??
Thu, 20 Sep 2007 11:14:34 +0200
Hello.
I have two questions abaout MSProject.
1) How can I get the languageID (with vb/vba) in MSProject.
Application.LanguageSettings.LanguageID(msoLanguageIDUI) does not work.
2) How can I open a document in MSProject without open another window?
With -Application.FileOpen filename -, it always started ...
|
Custom Cost Columns for FY
Wed, 12 Sep 2007 06:00:03 -0700
I have msp07. I have a project that spans 5 years. Is it possible to
create a custom cost field that is tailored to show the totals and rollup
for only the tasks within a 12 month period, i.e. 1 Oct - 30 Sep... So you
would have a Cost table showing such as Cost, FYCost07, FYCost08, FYCost09,
etc...
...
|
Extracting source code
Mon, 10 Sep 2007 06:11:53 -0700
Does anyone know of a way to extract all the source code from a vba
Access Project?
The reason I want to this is so I can document and browse it easier,
maybe even do UML.
Steve
...
|
How to find the first task visible on the display in vba
Fri, 07 Sep 2007 22:33:49 -0000
I am writing some for Project in vba and I need to determine which is
the first task that is physically visible to the user on the display
in the ActiveProject. Is there a simple way to do this in vba?
...
|
Resource Hours Roll-up
Thu, 23 Aug 2007 06:28:03 -0700
I have a need to roll-up resource names and work hours throughout the
schedule to each summary level task. I don't think Project does this with
any of it's standard functions and was trying to figure a good way to do it
using vba. Any thoughts?
Thanks, ...
|
|
|
msn bulamıyorum
Wed, 22 Aug 2007 19:24:01 -0700
msn gıremıyorum ekranda yoku 14.08.2007 pogram yukledım onda sıl
...
|
check for presence of text file
Mon, 20 Aug 2007 06:14:41 -0700
using 2003. I have a template MPP that I use to open an MPX file,
import tab delimited text via a map and then save as an MPP.
Problem. - I need to check for the presence of the text file. I can't
seem to find the right command - psuedo code:
open mpp template
check for text file (preferably a dialog box f ...
|
Project 2003 Standard - Macro Filter/Sort/Renumber-Tasks
Mon, 13 Aug 2007 21:29:23 +0530
Attempting to set up a macro that runs a filter, sorts the tasks
selected by 'finish date', and finally renumbers the tasks based on the
sort order. The tasks involved are not summary tasks and the filter is
'active selection' using a flag field to mark the tasks to be
selected/sorted. Thank you - y7c4g2k5
--
...
|
