Pages

Search

VBA - Filters Microsoft Project

VBA - Filters Microsoft Project

VBA - Filters

Posted: 23 Aug 2005 03:45 PM PDT

In article <com>,
"Satya Srinivas Kumar" <Satya Srinivas Kumar
@discussions.microsoft.com> wrote:
 

Satya,
I'm a little confused. Your post says you ARE able to export the
filtered tasks using Jack's VBA code (I assume you are referring to his
"Export hierarchy to Excel" macro), so what is the question or issue?

John
Project MVP

Parallel tasks with different durations displayed as critical

Posted: 23 Aug 2005 01:38 PM PDT

In article <com>,
"RonT" <microsoft.com> wrote:
 


RonT,
It's been a while since I worked with critical paths so I have forgotten
some of the little quirks that might be causing your problem. However,
if you don't mind sending your file via e-mail (zip it first), I would
be happy to take a look at it and give you an answer. With a real file
to review it is much easier to diagnose problems. If the file has
sensitive information, I can provide you with a macro that will
de-sensitize it or you can also go to fellow MVP, Jack Dahlgren's
website at: http://masamiki.com/project/macros.htm
His "scrub" macro is essentially the same as my de-sensitizing macro.

If you can't (or don't wish to) send your file, hopefully someone else
will read this thread and offer some suggestions.

John
Project MVP

All tasks begin on Project Start Date

Posted: 23 Aug 2005 10:42 AM PDT

Hi,

Here's the misunderstanding: No links apply unles you enter them!
Select teh tasks to be linked, click the "Link Tasks" button!
HTH
--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
+32-495-300 620
"stephanie" <microsoft.com> schreef in bericht
news:com... 
Yes, 
on 
Driven. 
mode 

How to display the full filepath on insert hyperlink in Word 2002

Posted: 23 Aug 2005 09:20 AM PDT

I take your point! Am new to this & thought I was in the Word one. Have
reposted to Word.
Thanks for your response...

(Can't see a way to remove my question from the Project newsgroup - is it
possible?)

"John" wrote:
 

Help!! on - work hour, % complete, Gantt Chart.. etc!

Posted: 23 Aug 2005 08:57 AM PDT

Hi,

1. Tools, Level Resources, put to "Manual" instead of "Automatic"
(And don't change dates of tasks unless you mean actuals. Let Project
propose the dates)

2. Could you be more precise? Putting a task to 100% complete does not
modify anything, it just changes work intop actual work. Besides, once a
task is 100% compelte, you can change about everything without Project
recalculating much.

3. Be sure to save a baseline before entering actuals (because entering an
actual finish will also change the finish date). Then use Tracking Gantt to
visualise the differences;
As for creating custom bars, see
http://www.mvps.org/project/faqs.htm
faq 31. Customizing Gantt Bars

4. That depends on your definition of alert etc.

HTH
--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
+32-495-300 620
"LY" <microsoft.com> schreef in bericht
news:com... 
2000. 
for 
range 
exact 
bar 
in 

Notes (Task Field) limitations and workarounds

Posted: 23 Aug 2005 08:47 AM PDT

Technet seemed to allude to the same, from Project 4/98 onwards... is there
anyway to setup a custom field that could display more than the first 256
characters or be searchable beyond the 256 char limit? Or should I just
resort to attaching/linking an OLE object (like an ascii text file) to the
notes field with the data in. I would rather avoid this as it unneccesarily
complicates finding the information.

Regards

J

"John" <com> wrote in message
news:microsoft.com... 
first 
excess of 
store 
limit 

Project printing help

Posted: 23 Aug 2005 08:09 AM PDT

Try zooming out from your current view. If you make the gantt chart smaller
that way, It will print more. Or larger paper? I usually use ledger size
paper to print decent sized schedules.

"Hogan" wrote:
 

Customizing Header

Posted: 23 Aug 2005 06:45 AM PDT

In article <com>,
"Tasha" <microsoft.com> wrote:
 


Tatum,
Yes, now it makes sense. Other than manually typing in the header
information for the filter range, the only way to get there is through a
VBA macro. The Date Range filter could be incorporated into the code
along with the FilePageSetupHeader Method.

Hope this helps.
John
Project MVP

overkill?

Posted: 22 Aug 2005 05:59 PM PDT


instauratio wrote: 

My personal experience in using scheduling software, Project or
otherwise, is that, for single resource projects, like the ones I do in
my consulting business, don't warrant this kind of software.
Basicially, it's because single resource projects are, by definition
"linear". That is, there is really only one path through the tasks
because there's only one person to do them. With an occasional
exception, say when I'm waiting for a reply from an outside source, I
can't really work on more than one task at a time. If I choose to, I
can switch from one task to the other, but I have a bad habit of doing
too much of that anyway, and try not to switch tasks because it is, by
definition and experience, inefficient. I've found it much more
effective to use a PIM on my computer and tie it to a PDA. I use a
customizable PIM that allows me to link items on my Todo list, so that
when one is done, the next one in sequence pops up. But I just don't
need the complexity of Critical Path Method when I can't really overlap
tasks anyway.
I hope this helps in your world.

Runtime Error

Posted: 22 Aug 2005 05:37 PM PDT

Scott:

I'd try uninstalling and reinstalling Office if the repair function doesn't
work. If you have follow-up questions, it would help, for starters, if you
posted the versions of the OS, Office and Project that you're using

--


Gary L. Chefetz, MVP
"We wrote the books on Project Server"
http://www.msprojectexperts.com

For Project Server FAQs visit
http://www.projectserverexperts.com

For Project FAQs visit
http://www.mvps.org/project


"Scott" <net> wrote in message
news:%2344%phx.gbl... 

Predecessors tab goes grey

Posted: 22 Aug 2005 03:46 PM PDT

Hi,

When teh tasks are consecutive in the list you can use Copy Down in the
predecesors columns (and all its excel-like variations)

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
+32-495-300 620
"brandon erndt" <microsoft.com> schreef in bericht
news:com... 
predecessor 
task 
comes