Diagrammme de Gantt: Récupérer ligne & colonne de la cellule sai si
11 réponses
Emmanuel
Bonsoir,
Y-a-t-il un moyen SIMPLE pour récupérer la ligne et la colonne d'un cellule
saisie dans le diagramme de Gantt ?
J'utilise actuellement: SelectTaskField Row:=ActiveCell.Task.ID,
ActiveCell.FieldName, RowRelative:=False
Mais si la cellule n'a pas de tâche déclarée alors ActiveCell.Task est
inconnu et la fonction plante et rentre en déboggage...
Donc je cherche une SIMPLE fonction pour obtenir la ligne et la colonne de
la saisie courante ?
Merci par avance, en attendant je cherche,
Emmanuel.
Project is different from Excel. The activecell has very little meaning. The cells in the table are just used to display information, not to hold information. This is why activecell does not have the same set of methods as Excel. The data is stored in project by task, so Project VBA works best on task, resource and assignment objects instead of cells and rows. Once you understand that, then the fact that there is no function to get the line of an empty active cell is not a surprise. The line you are accessing has no task associated with it. So you can not get any information about it directly.
A blank line in project is like a space between words in a sentence. It has almost no meaning and exists only to make something easier to read.
-Jack Dahlgren "
Donc au moins c'est réglé, dommage.
A bientôt et merci de votre aide préciseuse, Emmanuel REGIS.
avec plaisir! Essayez sur le forum U.S. y'a des bêtes là bas...
J'ai la réponse Vincent:
"
Emmanuel,
Project is different from Excel. The activecell has very little meaning. The
cells in the table are just used to display information, not to hold
information. This is why activecell does not have the same set of methods as
Excel. The data is stored in project by task, so Project VBA works best on
task, resource and assignment objects instead of cells and rows. Once you
understand that, then the fact that there is no function to get the line of
an empty active cell is not a surprise. The line you are accessing has no
task associated with it. So you can not get any information about it
directly.
A blank line in project is like a space between words in a sentence. It has
almost no meaning and exists only to make something easier to read.
-Jack Dahlgren
"
Donc au moins c'est réglé, dommage.
A bientôt et merci de votre aide préciseuse,
Emmanuel REGIS.
avec plaisir! Essayez sur le forum U.S. y'a des bêtes là bas...
Project is different from Excel. The activecell has very little meaning. The cells in the table are just used to display information, not to hold information. This is why activecell does not have the same set of methods as Excel. The data is stored in project by task, so Project VBA works best on task, resource and assignment objects instead of cells and rows. Once you understand that, then the fact that there is no function to get the line of an empty active cell is not a surprise. The line you are accessing has no task associated with it. So you can not get any information about it directly.
A blank line in project is like a space between words in a sentence. It has almost no meaning and exists only to make something easier to read.
-Jack Dahlgren "
Donc au moins c'est réglé, dommage.
A bientôt et merci de votre aide préciseuse, Emmanuel REGIS.
avec plaisir! Essayez sur le forum U.S. y'a des bêtes là bas...
