Try to modify a row, but found out Task ID and row number are

Try to modify a row, but found out Task ID and row number are

Post by c3hpbmthbm » Wed, 24 Jun 2009 03:31:02


Dear Jan,
Thanks for quick reply.
I have tried your first approach.
It seems working, but there is some issue. The original file shows 800
lines. After the script, it shows 1373 lines. Is there anyway we can still
showing 800 lines?
(I guess the file was used some kind of filter or something.)

I will try the second approach and tell you if it works. Thank you so much.
--
Walt
 
 
 

Try to modify a row, but found out Task ID and row number are

Post by Jan De Mes » Wed, 24 Jun 2009 14:29:36

Hi,

Some kind of filter, yes, that is exactly why rows were not equal to ID's!
Normally the filter applied is visible (in the little filter window), or you
ccan read the name in Project menu, Filtered for...; if you note its name,
you can re-apply it after the macro.
To automate it start the macro with
FilterName=activeproject.currentfilter
and you end it with
Filterapply FilterName

HTH

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://www.yqcomputer.com/

 
 
 

Try to modify a row, but found out Task ID and row number are

Post by c3hpbmthbm » Wed, 24 Jun 2009 21:50:01

Thanks! Jan. I thought the same. Really appreciate your help!
--
Walt


"Jan De Messemaeker" wrote:

 
 
 

Try to modify a row, but found out Task ID and row number are

Post by c3hpbmthbm » Thu, 25 Jun 2009 03:27:01

Dear Jan,
I define "Dim FilterName as String" and watch the value.

After
FilterName=activeproject.currentfilter

The FilterName is "AllTasks". Did I do something wrong? There is some filter
on "% Complete" and "Project Name" columns.
--
Walt


"Jan De Messemaeker" wrote:

 
 
 

Try to modify a row, but found out Task ID and row number are

Post by Jan De Mes » Thu, 25 Jun 2009 04:32:45

Hi,

A-Ha!
It's not the filter, it's the fact that certain summary tasks are rolled
up... which is much harder to memorize I'm afraid..
Sorry, but i do not have the time to write this coding here and now.
HTH


--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf
"sxinkang" < XXXX@XXXXX.COM > wrote in message
news: XXXX@XXXXX.COM ...


 
 
 

Try to modify a row, but found out Task ID and row number are

Post by c3hpbmthbm » Thu, 25 Jun 2009 21:35:03

Thanks for reply.
--
Walt


"Jan De Messemaeker" wrote: