the Function "Timescaleedit" and selecting a field

[MAT]

Hi..
I have 2 questions.
1:
I try to use the function "timescaleedit" to change the timesacale, but i
get always an error message, wenn i try to make the majorunits "day" and
minorunits "hour". Wenn i make them year-month or sth else, then there is no
problem.. What do i make false?

2: Is there any way to select a filed in the table (where u see the work and
actual work of a ressource) in the "task usage" sheet ?

Any ideas?
Thx..........

 

[John]

Hi..
I have 2 questions.
1:
I try to use the function "timescaleedit" to change the timesacale, but i
get always an error message, wenn i try to make the majorunits "day" and
minorunits "hour". Wenn i make them year-month or sth else, then there is no
problem.. What do i make false?

2: Is there any way to select a filed in the table (where u see the work and
actual work of a ressource) in the "task usage" sheet ?

Any ideas?
Thx..........

MAT,
First, you might want to fix your spell and grammar checker - they
ain't working!

1. What error message do you get? Can you give us a sample of the actual
line of code you are using?

2. You are asking about views and the obvious answer is to select a
field by clicking on it. However, there must be more to your question.
Are you trying to select something using VBA? If so, why do you feel you
need to select it? VBA can access Project objects directly in the
background (i.e. no selection necessary). Therefore it doesn't matter
what view happens to be active.

Hope this helps.
John
Project MVP

 

[MAT]

Hi John.
I want to do exactly this:
With a Macro, i want to change the timescale and make it day-hour. Then for
a selected task i look for every resource if they have in any timeinterwal
more or less work from 1 Hours (for example ressource1 works 0,75 hour
between 14:00- 15:00 in 15/08/2005).
So insatead of messageboxes, the makro has to select the ressource (dark
blue) and mark the field in which the work is not 1 hour in the task-usage
sheet.
thx..
bye...

 

[John]

Hi John.
I want to do exactly this:
With a Macro, i want to change the timescale and make it day-hour. Then for
a selected task i look for every resource if they have in any timeinterwal
more or less work from 1 Hours (for example ressource1 works 0,75 hour
between 14:00- 15:00 in 15/08/2005).
So insatead of messageboxes, the makro has to select the ressource (dark
blue) and mark the field in which the work is not 1 hour in the task-usage
sheet.
thx..
bye...

MAT,
Proofreading a message before you send it does two things. First, it
makes the message a lot easier to read and understand. Second, it is
simply more professional. Enough said.

You didn't answer my first question. Your original message said you got
an error when you tried to use the TimescaleEdit Method but you didn't
say what the error was nor did you provide the line of code you used. I
understand what you want to do with the timescale but I haven't a clue
why it "didn't work" for you.

I'm not sure I completely follow what you are trying to do with respect
to marking the field for resource assignments not equal to 1 hour. It
sounds like you would like to mark individual cells in the data table
(right side) of the Task Usage view. Project does not have a feature
that allows marking individual cells in timescaled views. The best you
will be able to do in Project is to "mark" the assignment row as a
whole. Or, if you really need to mark individual timescale cells, the
data will have to be exported to Excel and then marked.

John
Project MVP