Project Window Activation from Resource Sheet if any
| Author |
Message |
|
Ronald Dodg
#1 / 19
|
 Project Window Activation from Resource Sheet if any How do I check a project file if there's a Project Window (I.e. "Project1"), and if so, how to activate it. There's a few things that I have found as I been opening various project files and then updating an Excel file from the data in the various project files of which I am attempting to automate. It doesn't appear to me there is truely a Windows group, so what do I need to do? I have tried the following only to learn it's not really a collection: Dim wd as Window
For Each wd in Projects("<Project Name>").Windows
<Statements to activate the Project Window>
Next
Occasionally, there is a project that has only one (1) linked source that
opened up, so there is no window by the name of "Project1", so I have to go
to the linked source window and then run my codes on that window. I need to
be able to detect this too.
--
Ronald R Dodge, Jr
Production Statistician
Master MOUS 2000
|
| Wed, 11 May 2005 06:27:24 GMT |
|
 |
|
Rod Gil
#2 / 19
|
Project Window Activation from Resource Sheet if any Is your question "How do I test to see if a particular project file is open?" then try: Dim Proj as Project
For Each Proj in Application.Projects
If Proj.Name="<Proejct Name>" Then
'
Endif
Next
--
Visit www.mvps.org/project/ for the Project MVP's FAQ and third party
add-ons
Rod Gill
Microsoft Project MVP
Visit www.projectlearning.com for customized Project and Office VBA macros
and Project companion software
Quote: > How do I check a project file if there's a Project Window (I.e. "Project1"), > and if so, how to activate it. There's a few things that I have found as I > been opening various project files and then updating an Excel file from the > data in the various project files of which I am attempting to automate. It > doesn't appear to me there is truely a Windows group, so what do I need to > do? I have tried the following only to learn it's not really a collection: > Dim wd as Window
> For Each wd in Projects("<Project Name>").Windows
> <Statements to activate the Project Window>
> Next
> Occasionally, there is a project that has only one (1) linked source that
> opened up, so there is no window by the name of "Project1", so I have to
go
> to the linked source window and then run my codes on that window. I need
to
> be able to detect this too.
> --
> Ronald R Dodge, Jr
> Production Statistician
> Master MOUS 2000
|
| Thu, 12 May 2005 09:11:16 GMT |
|
|
|
Ronald Dodg
#3 / 19
|
Project Window Activation from Resource Sheet if any The project file is open, but there may or may not be an actual project window. If there isn't anything for the project window or if there's only one resource open for the project window, there isn't a project window within the project file. --
Ronald R Dodge, Jr
Production Statistician
Master MOUS 2000
Quote: > Is your question "How do I test to see if a particular project file is > open?" then try: > Dim Proj as Project
> For Each Proj in Application.Projects
> If Proj.Name="<Proejct Name>" Then
> '
> Endif
> Next
> --
> Visit www.mvps.org/project/ for the Project MVP's FAQ and third party
> add-ons
> Rod Gill
> Microsoft Project MVP
> Visit www.projectlearning.com for customized Project and Office VBA macros
> and Project companion software
> > How do I check a project file if there's a Project Window (I.e.
> "Project1"),
> > and if so, how to activate it. There's a few things that I have found
as
> I
> > been opening various project files and then updating an Excel file from
> the
> > data in the various project files of which I am attempting to automate.
> It
> > doesn't appear to me there is truely a Windows group, so what do I need
to
> > do? I have tried the following only to learn it's not really a
> collection:
> > Dim wd as Window
> > For Each wd in Projects("<Project Name>").Windows
> > <Statements to activate the Project Window>
> > Next
> > Occasionally, there is a project that has only one (1) linked source
that
> > opened up, so there is no window by the name of "Project1", so I have to
> go
> > to the linked source window and then run my codes on that window. I
need
> to
> > be able to detect this too.
> > --
> > Ronald R Dodge, Jr
> > Production Statistician
> > Master MOUS 2000
|
| Sun, 15 May 2005 01:16:02 GMT |
|
|
|
Jan De Messemaeke
#4 / 19
|
Project Window Activation from Resource Sheet if any Hi, I wish I understood some of this. "The project file is open, but there may or may not be an actual project
Quote: > window."
??? Do you mean that the Microsoft Project window can be minimized? If one project file is open, there *is* an activeproject isn't there? "If there isn't anything for the project window or if there's only
Quote: > one resource open for the project window, there isn't a project window
> within the project file."
Please help me, this is Russian or Chinese to me. Even if a project has no resources whatsoever there is a project window as soon as the project is open! Sorry... I am very curious.
--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
Project Management Consultancy
Prom+ade BVBA
32-495-300 620
Quote: > The project file is open, but there may or may not be an actual project > window. If there isn't anything for the project window or if there's only > one resource open for the project window, there isn't a project window > within the project file. > --
> Ronald R Dodge, Jr
> Production Statistician
> Master MOUS 2000
> > Is your question "How do I test to see if a particular project file is
> > open?" then try:
> > Dim Proj as Project
> > For Each Proj in Application.Projects
> > If Proj.Name="<Proejct Name>" Then
> > '
> > Endif
> > Next
> > --
> > Visit www.mvps.org/project/ for the Project MVP's FAQ and third party
> > add-ons
> > Rod Gill
> > Microsoft Project MVP
> > Visit www.projectlearning.com for customized Project and Office VBA
macros
> > and Project companion software
> > > How do I check a project file if there's a Project Window (I.e.
> > "Project1"),
> > > and if so, how to activate it. There's a few things that I have found
> as
> > I
> > > been opening various project files and then updating an Excel file
from
> > the
> > > data in the various project files of which I am attempting to
automate.
> > It
> > > doesn't appear to me there is truely a Windows group, so what do I
need
> to
> > > do? I have tried the following only to learn it's not really a
> > collection:
> > > Dim wd as Window
> > > For Each wd in Projects("<Project Name>").Windows
> > > <Statements to activate the Project Window>
> > > Next
> > > Occasionally, there is a project that has only one (1) linked source
> that
> > > opened up, so there is no window by the name of "Project1", so I have
to
> > go
> > > to the linked source window and then run my codes on that window. I
> need
> > to
> > > be able to detect this too.
> > > --
> > > Ronald R Dodge, Jr
> > > Production Statistician
> > > Master MOUS 2000
|
| Sun, 15 May 2005 02:22:49 GMT |
|
|
|
Ronald Dodg
#5 / 19
|
Project Window Activation from Resource Sheet if any Let me try to put it in another format Project File (Name of File.mpp)
Windows:
Resource Sheet (this shows for all project files)
Linked Resource if there is only one valid and found linked resource
file. (with only one linked resource file open)
Project Window (I.e. Project1) , if there is more than 1 valid and
found linked resource file. (must have multiple linked resource files open)
Please note in the above the following:
If there is no linked resources, there is only the resource sheet window.
If there is only one linked resource file open for the project file, in
addition to the resource sheet window, the name of the resouce file appears
as the window caption/name of the second window.
If there is more than one linked resource file open for the project file, in
addition to the resource sheet, the second window has the caption/name of
"Project#".
In rare cases, I have seen multiple Project windows (I.e. "Project1" and
"Project2") within the same project file (I.e. "My Project File.mpp")
Note: This is under the assumption that only one project file is open at a
time, and it opens and shares all resource files linked to the project
--
Ronald R Dodge, Jr
Production Statistician
Master MOUS 2000
Quote: > Hi, > I wish I understood some of this. > "The project file is open, but there may or may not be an actual project
> > window."
> ??? Do you mean that the Microsoft Project window can be minimized?
> If one project file is open, there *is* an activeproject isn't there?
> "If there isn't anything for the project window or if there's only
> > one resource open for the project window, there isn't a project window
> > within the project file."
> Please help me, this is Russian or Chinese to me. Even if a project has no
> resources whatsoever there is a project window as soon as the project is
> open!
> Sorry... I am very curious.
> --
> Jan De Messemaeker
> Microsoft Project Most Valuable Professional
> Project Management Consultancy
> Prom+ade BVBA
> 32-495-300 620
> > The project file is open, but there may or may not be an actual project
> > window. If there isn't anything for the project window or if there's
only
> > one resource open for the project window, there isn't a project window
> > within the project file.
> > --
> > Ronald R Dodge, Jr
> > Production Statistician
> > Master MOUS 2000
> > > Is your question "How do I test to see if a particular project file is
> > > open?" then try:
> > > Dim Proj as Project
> > > For Each Proj in Application.Projects
> > > If Proj.Name="<Proejct Name>" Then
> > > '
> > > Endif
> > > Next
> > > --
> > > Visit www.mvps.org/project/ for the Project MVP's FAQ and third party
> > > add-ons
> > > Rod Gill
> > > Microsoft Project MVP
> > > Visit www.projectlearning.com for customized Project and Office VBA
> macros
> > > and Project companion software
> > > > How do I check a project file if there's a Project Window (I.e.
> > > "Project1"),
> > > > and if so, how to activate it. There's a few things that I have
found
> > as
> > > I
> > > > been opening various project files and then updating an Excel file
> from
> > > the
> > > > data in the various project files of which I am attempting to
> automate.
> > > It
> > > > doesn't appear to me there is truely a Windows group, so what do I
> need
> > to
> > > > do? I have tried the following only to learn it's not really a
> > > collection:
> > > > Dim wd as Window
> > > > For Each wd in Projects("<Project Name>").Windows
> > > > <Statements to activate the Project Window>
> > > > Next
> > > > Occasionally, there is a project that has only one (1) linked source
> > that
> > > > opened up, so there is no window by the name of "Project1", so I
have
> to
> > > go
> > > > to the linked source window and then run my codes on that window. I
> > need
> > > to
> > > > be able to detect this too.
> > > > --
> > > > Ronald R Dodge, Jr
> > > > Production Statistician
> > > > Master MOUS 2000
|
| Sun, 15 May 2005 03:33:42 GMT |
|
|
|
Jan De Messemaeke
#6 / 19
|
Project Window Activation from Resource Sheet if any Hello, Quite a lot of assumptions, how on earth could we know all that?
Now let me try to translate that in Project language.
First, All projects have a resource sheet view, and all projects have scores
of othe rviews as well; which one shows at open depends on which one was
opened at last save/close; the fact that you see a resource sheet at open
time thus is completely meaningless and has no bearing on othe
characteristics of the file.
I think the process you try to describe is the opening of a resource pool.
On top of that (another assumption) you select at open the third option
("Open Pool and all sharer files")
Then you start describing what Project does in such a case.
So you want to know which other projects are open but for your resource
pool?
For each apr in projects
if not apr.name = <Name of the resource pool> then
apr.activate
is one way.
But finally, if you really want to wortk in Project through VBA, DO LEARN
SOMETHING ABOUT PROJECT.
What is a project, a view, a resource pool, a sharer...
If not you will have more questions than answers every step of the way!
HTH
--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
Project Management Consultancy
Prom+ade BVBA
32-495-300 620
Quote: > Let me try to put it in another format > Project File (Name of File.mpp)
> Windows:
> Resource Sheet (this shows for all project files)
> Linked Resource if there is only one valid and found linked
resource
> file. (with only one linked resource file open)
> Project Window (I.e. Project1) , if there is more than 1 valid and
> found linked resource file. (must have multiple linked resource files
open)
> Please note in the above the following:
> If there is no linked resources, there is only the resource sheet window.
> If there is only one linked resource file open for the project file, in
> addition to the resource sheet window, the name of the resouce file
appears
> as the window caption/name of the second window.
> If there is more than one linked resource file open for the project file,
in
> addition to the resource sheet, the second window has the caption/name of
> "Project#".
> In rare cases, I have seen multiple Project windows (I.e. "Project1" and
> "Project2") within the same project file (I.e. "My Project File.mpp")
> Note: This is under the assumption that only one project file is open at
a
> time, and it opens and shares all resource files linked to the project
> --
> Ronald R Dodge, Jr
> Production Statistician
> Master MOUS 2000
> > Hi,
> > I wish I understood some of this.
> > "The project file is open, but there may or may not be an actual project
> > > window."
> > ??? Do you mean that the Microsoft Project window can be minimized?
> > If one project file is open, there *is* an activeproject isn't there?
> > "If there isn't anything for the project window or if there's only
> > > one resource open for the project window, there isn't a project window
> > > within the project file."
> > Please help me, this is Russian or Chinese to me. Even if a project has
no
> > resources whatsoever there is a project window as soon as the project is
> > open!
> > Sorry... I am very curious.
> > --
> > Jan De Messemaeker
> > Microsoft Project Most Valuable Professional
> > Project Management Consultancy
> > Prom+ade BVBA
> > 32-495-300 620
> > > The project file is open, but there may or may not be an actual
project
> > > window. If there isn't anything for the project window or if there's
> only
> > > one resource open for the project window, there isn't a project window
> > > within the project file.
> > > --
> > > Ronald R Dodge, Jr
> > > Production Statistician
> > > Master MOUS 2000
> > > > Is your question "How do I test to see if a particular project file
is
> > > > open?" then try:
> > > > Dim Proj as Project
> > > > For Each Proj in Application.Projects
> > > > If Proj.Name="<Proejct Name>" Then
> > > > '
> > > > Endif
> > > > Next
> > > > --
> > > > Visit www.mvps.org/project/ for the Project MVP's FAQ and third
party
> > > > add-ons
> > > > Rod Gill
> > > > Microsoft Project MVP
> > > > Visit www.projectlearning.com for customized Project and Office VBA
> > macros
> > > > and Project companion software
> > > > > How do I check a project file if there's a Project Window (I.e.
> > > > "Project1"),
> > > > > and if so, how to activate it. There's a few things that I have
> found
> > > as
> > > > I
> > > > > been opening various project files and then updating an Excel file
> > from
> > > > the
> > > > > data in the various project files of which I am attempting to
> > automate.
> > > > It
> > > > > doesn't appear to me there is truely a Windows group, so what do I
> > need
> > > to
> > > > > do? I have tried the following only to learn it's not really a
> > > > collection:
> > > > > Dim wd as Window
> > > > > For Each wd in Projects("<Project Name>").Windows
> > > > > <Statements to activate the Project Window>
> > > > > Next
> > > > > Occasionally, there is a project that has only one (1) linked
source
> > > that
> > > > > opened up, so there is no window by the name of "Project1", so I
> have
> > to
> > > > go
> > > > > to the linked source window and then run my codes on that window.
I
> > > need
> > > > to
> > > > > be able to detect this too.
> > > > > --
> > > > > Ronald R Dodge, Jr
> > > > > Production Statistician
> > > > > Master MOUS 2000
|
| Sun, 15 May 2005 03:56:45 GMT |
|
|
|
Ronald Dodg
#7 / 19
|
Project Window Activation from Resource Sheet if any I admit, I am relatively new to Project Objects in VBA. I have taken up a 2 day training course paid by the company in Project 98, so I do know some things about it, but as the old saying goes, it takes experience to know how to really work it. I am not new to VBA in general though. I have worked in Excel VBA for quite a bit (going on 4 years now), and I have taken on some training courses in VB6 of which there's a lot of similarities in general. BTW, I did get my VBA working properly for what I was attempting to do. It was a bit of a trick, and that's given the fact that the code may not necessarily know the name of the resource file(s) that are being opened, at least not in VBA. What I had done was used the InStr function for each window in Application.Windows.Caption (assuming that the file did open of which if it couldn't open with the third option, it would skip the project and go to the next project file) and look for the "Project" name in it. This Application.Windows through me off for a loop cause in Excel to set window settings on a workbook, you use Application.Workbooks("Book1.xls").Windows.<Property>, but for the same property or set of properties in Project, I had to use Application.Windows.<Property> There were a lot of issues that I dealt with in Project/Excel to get them 2
talking to each other, so as I don't have to do the tasks for 20 different
Project Files. We would have less, but us as a company has learned, if
there's like more than 30 linked resources to a single project file, we
start running into issues with opening the project file, so that's the
biggest reason why all of the tasks are being filtered, then copied in
Project, and then pasted into Excel.
I'm about to run a final test this evening, but will have to wait til all
office personnel have left for the day so as I can be sure that no one is
making changes to the impacted files that I'm testing my code on.
Issues addressed:
Getting the appropriate windows (explained above via the Application.Windows
rather than Application.Projects().Windows
Making sure the Object Variable is only set to a Project 98 application when
needed (put in a 5 second sleep time to give the code a chance to set the
variable to nothing cause it worked fine when ran each loop individually,
but skipped every other file when ran all at once)
Not saving project file since the code is only meant to copy and paste
between Project and Excel (This was resolved by using FileExit
(pjDoNotSave))
When using the PasteSpecial (Worksheet Object) in Excel, and had it
specified to do in "Microsoft Excel 8.0 Object", it did in that format and
in "Microsoft Project 8.0 Project Object" format. (Had to use
Workbooks(<WorkbookSpecName>).Worksheets(<SheetName>).Pictures to remove the
Project Object paste)
The issues above were the main issues that I had to do some hunting around
to resolve.
Remaining Issue that happens both by hand and in automation:
When using the PasteSpecial (Worksheet Object) in Excel to paste Project 98
data into Excel at the specified location (as has been set by the active
cell), get a general error message "File not found" with no error number or
anything.
ADDITIONAL INFO ABOUT MY KNOWLEDGE OF VBA IN GENERAL AND IN EXCEL
Given I am relatively new to Project's Component Object Model (COM), it did
take me longer to resolve these issues than it would have been, if I knew
them pretty much inside out like I do with Excel Objects. On the other
hand, given I do know how to look for certain things via the Watch, Local,
and Intermediate Windows, understand the use of On Error statements,
Variable declarations, the difference of Sub vs Function along with the uses
of both, and how to read through help files and msdn.microsoft.com/library,
all of these things has helped me resolve the issues.
Just so you know, I use VBA in Excel to control just about every little
aspect of Excel due to the various issues that I have ran into in Excel
dealing with arbutary limitations (RAM usage limit regardless how much is on
the system, can only have so many cells linked to external workbooks else it
will crash, F9 doesn't calculate everything every single time it is pressed
even though it suppose to, and the list goes on), and other issues like
redundent calculations in autocalc to the point it takes so much more time
than it would to do the same calcs when controlled by VBA. Even though I
know Excel quite well, it still doesn't mean I know every little thing in
Excel. Just thought I would point that out just so you wouldn't get the
idea that I think I know everything cause that's next to impossible for
someone to know every thing that there is to know about. I do know a lot of
things about computers though as I been working with computers for 18 years
now.
--
Ronald R Dodge, Jr
Production Statistician
Master MOUS 2000
Quote: > Hello, > Quite a lot of assumptions, how on earth could we know all that?
> Now let me try to translate that in Project language.
> First, All projects have a resource sheet view, and all projects have
scores
> of othe rviews as well; which one shows at open depends on which one was
> opened at last save/close; the fact that you see a resource sheet at open
> time thus is completely meaningless and has no bearing on othe
> characteristics of the file.
> I think the process you try to describe is the opening of a resource pool.
> On top of that (another assumption) you select at open the third option
> ("Open Pool and all sharer files")
> Then you start describing what Project does in such a case.
> So you want to know which other projects are open but for your resource
> pool?
> For each apr in projects
> if not apr.name = <Name of the resource pool> then
> apr.activate
> is one way.
> But finally, if you really want to wortk in Project through VBA, DO LEARN
> SOMETHING ABOUT PROJECT.
> What is a project, a view, a resource pool, a sharer...
> If not you will have more questions than answers every step of the way!
> HTH
> --
> Jan De Messemaeker
> Microsoft Project Most Valuable Professional
> Project Management Consultancy
> Prom+ade BVBA
> 32-495-300 620
> > Let me try to put it in another format
> > Project File (Name of File.mpp)
> > Windows:
> > Resource Sheet (this shows for all project files)
> > Linked Resource if there is only one valid and found linked
> resource
> > file. (with only one linked resource file open)
> > Project Window (I.e. Project1) , if there is more than 1 valid
and
> > found linked resource file. (must have multiple linked resource files
> open)
> > Please note in the above the following:
> > If there is no linked resources, there is only the resource sheet
window.
> > If there is only one linked resource file open for the project file, in
> > addition to the resource sheet window, the name of the resouce file
> appears
> > as the window caption/name of the second window.
> > If there is more than one linked resource file open for the project
file,
> in
> > addition to the resource sheet, the second window has the caption/name
of
> > "Project#".
> > In rare cases, I have seen multiple Project windows (I.e. "Project1" and
> > "Project2") within the same project file (I.e. "My Project File.mpp")
> > Note: This is under the assumption that only one project file is open
at
> a
> > time, and it opens and shares all resource files linked to the project
> > --
> > Ronald R Dodge, Jr
> > Production Statistician
> > Master MOUS 2000
> > > Hi,
> > > I wish I understood some of this.
> > > "The project file is open, but there may or may not be an actual
project
> > > > window."
> > > ??? Do you mean that the Microsoft Project window can be minimized?
> > > If one project file is open, there *is* an activeproject isn't there?
> > > "If there isn't anything for the project window or if there's only
> > > > one resource open for the project window, there isn't a project
window
> > > > within the project file."
> > > Please help me, this is Russian or Chinese to me. Even if a project
has
> no
> > > resources whatsoever there is a project window as soon as the project
is
> > > open!
> > > Sorry... I am very curious.
> > > --
> > > Jan De Messemaeker
> > > Microsoft Project Most Valuable Professional
> > > Project Management Consultancy
> > > Prom+ade BVBA
> > > 32-495-300 620
> > > > The project file is open, but there may or may not be an actual
> project
> > > > window. If there isn't anything for the project window or if
there's
> > only
> > > > one resource open for the project window, there isn't a project
window
> > > > within the project file.
> > > > --
> > > > Ronald R Dodge, Jr
> > > > Production Statistician
> > > > Master MOUS 2000
> > > > > Is your question "How do I test to see if a particular project
file
> is
> > > > > open?" then try:
> > > > > Dim Proj as Project
> > > > > For Each Proj in Application.Projects
> > > > > If Proj.Name="<Proejct Name>" Then
> > > > > '
> > > > > Endif
> > > > > Next
> > > > > --
> > > > > Visit www.mvps.org/project/ for the Project MVP's FAQ and third
> party
> > > > > add-ons
> > > > > Rod Gill
> > > > > Microsoft Project MVP
> > > > > Visit www.projectlearning.com for customized Project and Office
VBA
> > > macros
> > > > > and
... read more »
|
| Sun, 15 May 2005 05:49:00 GMT |
|
|
|
Jan De Messemaeke
#8 / 19
|
Project Window Activation from Resource Sheet if any OK, OK, sorry if I was a bit harsh. Still, it would make your questions much more easier to read and to reply to shoudl you switch to Project's vocabulary. For instance, you write: "if there's like more than 30 linked resources to a single project file, we
start running into issues with opening the project file"
There is no such thing as linked resources to a project file. I think you
mean projects linked to a resource pool, so I think you mean
"if there's like more than 30 projects linked to a single resource pool, we
start running into issues with opening the pool,"
Then I would be encouraged to go on reading, I do not have to guess what you
mean.
Just a suggestion meant to help you, when your questions are in Project
language, more people will be motib-vated to help you.
Greetings,
--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
Project Management Consultancy
Prom+ade BVBA
32-495-300 620
Quote: > I admit, I am relatively new to Project Objects in VBA. I have taken up a 2 > day training course paid by the company in Project 98, so I do know some > things about it, but as the old saying goes, it takes experience to know how > to really work it. I am not new to VBA in general though. I have worked in > Excel VBA for quite a bit (going on 4 years now), and I have taken on some > training courses in VB6 of which there's a lot of similarities in general. > BTW, I did get my VBA working properly for what I was attempting to do. It > was a bit of a trick, and that's given the fact that the code may not > necessarily know the name of the resource file(s) that are being opened, at > least not in VBA. What I had done was used the InStr function for each > window in Application.Windows.Caption (assuming that the file did open of > which if it couldn't open with the third option, it would skip the project > and go to the next project file) and look for the "Project" name in it. > This Application.Windows through me off for a loop cause in Excel to set > window settings on a workbook, you use > Application.Workbooks("Book1.xls").Windows.<Property>, but for the same > property or set of properties in Project, I had to use > Application.Windows.<Property> > There were a lot of issues that I dealt with in Project/Excel to get them
2
> talking to each other, so as I don't have to do the tasks for 20 different
> Project Files. We would have less, but us as a company has learned, if
> there's like more than 30 linked resources to a single project file, we
> start running into issues with opening the project file, so that's the
> biggest reason why all of the tasks are being filtered, then copied in
> Project, and then pasted into Excel.
> I'm about to run a final test this evening, but will have to wait til all
> office personnel have left for the day so as I can be sure that no one is
> making changes to the impacted files that I'm testing my code on.
> Issues addressed:
> Getting the appropriate windows (explained above via the
Application.Windows
> rather than Application.Projects().Windows
> Making sure the Object Variable is only set to a Project 98 application
when
> needed (put in a 5 second sleep time to give the code a chance to set the
> variable to nothing cause it worked fine when ran each loop individually,
> but skipped every other file when ran all at once)
> Not saving project file since the code is only meant to copy and paste
> between Project and Excel (This was resolved by using FileExit
> (pjDoNotSave))
> When using the PasteSpecial (Worksheet Object) in Excel, and had it
> specified to do in "Microsoft Excel 8.0 Object", it did in that format and
> in "Microsoft Project 8.0 Project Object" format. (Had to use
> Workbooks(<WorkbookSpecName>).Worksheets(<SheetName>).Pictures to remove
the
> Project Object paste)
> The issues above were the main issues that I had to do some hunting around
> to resolve.
> Remaining Issue that happens both by hand and in automation:
> When using the PasteSpecial (Worksheet Object) in Excel to paste Project
98
> data into Excel at the specified location (as has been set by the active
> cell), get a general error message "File not found" with no error number
or
> anything.
> ADDITIONAL INFO ABOUT MY KNOWLEDGE OF VBA IN GENERAL AND IN EXCEL
> Given I am relatively new to Project's Component Object Model (COM), it
did
> take me longer to resolve these issues than it would have been, if I knew
> them pretty much inside out like I do with Excel Objects. On the other
> hand, given I do know how to look for certain things via the Watch, Local,
> and Intermediate Windows, understand the use of On Error statements,
> Variable declarations, the difference of Sub vs Function along with the
uses
> of both, and how to read through help files and
msdn.microsoft.com/library, Quote: > all of these things has helped me resolve the issues. > Just so you know, I use VBA in Excel to control just about every little
> aspect of Excel due to the various issues that I have ran into in Excel
> dealing with arbutary limitations (RAM usage limit regardless how much is
on
> the system, can only have so many cells linked to external workbooks else
it
> will crash, F9 doesn't calculate everything every single time it is
pressed
> even though it suppose to, and the list goes on), and other issues like
> redundent calculations in autocalc to the point it takes so much more time
> than it would to do the same calcs when controlled by VBA. Even though I
> know Excel quite well, it still doesn't mean I know every little thing in
> Excel. Just thought I would point that out just so you wouldn't get the
> idea that I think I know everything cause that's next to impossible for
> someone to know every thing that there is to know about. I do know a lot
of
> things about computers though as I been working with computers for 18
years
> now.
> --
> Ronald R Dodge, Jr
> Production Statistician
> Master MOUS 2000
> > Hello,
> > Quite a lot of assumptions, how on earth could we know all that?
> > Now let me try to translate that in Project language.
> > First, All projects have a resource sheet view, and all projects have
> scores
> > of othe rviews as well; which one shows at open depends on which one was
> > opened at last save/close; the fact that you see a resource sheet at
open
> > time thus is completely meaningless and has no bearing on othe
> > characteristics of the file.
> > I think the process you try to describe is the opening of a resource
pool.
> > On top of that (another assumption) you select at open the third option
> > ("Open Pool and all sharer files")
> > Then you start describing what Project does in such a case.
> > So you want to know which other projects are open but for your resource
> > pool?
> > For each apr in projects
> > if not apr.name = <Name of the resource pool> then
> > apr.activate
> > is one way.
> > But finally, if you really want to wortk in Project through VBA, DO
LEARN
> > SOMETHING ABOUT PROJECT.
> > What is a project, a view, a resource pool, a sharer...
> > If not you will have more questions than answers every step of the way!
> > HTH
> > --
> > Jan De Messemaeker
> > Microsoft Project Most Valuable Professional
> > Project Management Consultancy
> > Prom+ade BVBA
> > 32-495-300 620
> > > Let me try to put it in another format
> > > Project File (Name of File.mpp)
> > > Windows:
> > > Resource Sheet (this shows for all project files)
> > > Linked Resource if there is only one valid and found linked
> > resource
> > > file. (with only one linked resource file open)
> > > Project Window (I.e. Project1) , if there is more than 1 valid
> and
> > > found linked resource file. (must have multiple linked resource files
> > open)
> > > Please note in the above the following:
> > > If there is no linked resources, there is only the resource sheet
> window.
> > > If there is only one linked resource file open for the project file,
in
> > > addition to the resource sheet window, the name of the resouce file
> > appears
> > > as the window caption/name of the second window.
> > > If there is more than one linked resource file open for the project
> file,
> > in
> > > addition to the resource sheet, the second window has the caption/name
> of
> > > "Project#".
> > > In rare cases, I have seen multiple Project windows (I.e. "Project1"
and
> > > "Project2") within the same project file (I.e. "My Project File.mpp")
> > > Note: This is under the assumption that only one project file is open
> at
> > a
> > > time, and it opens and shares all resource files linked to the project
> > > --
> > > Ronald R Dodge, Jr
> > > Production Statistician
> > > Master MOUS 2000
> > > > Hi,
> > > > I wish I understood some of this.
> > > > "The project file is open, but there may or may not be an actual
> project
> > > > > window."
> > > > ??? Do you mean that the Microsoft Project window can be minimized?
> > > > If one project file is open, there *is* an activeproject isn't
there?
> > > > "If there isn't anything for the project window or if there's only
> > > > > one resource open for the project window, there isn't a project
> window
> > > > > within the project file."
> > > > Please help me, this is Russian or Chinese to me. Even if a project
> has
> > no
> > > > resources whatsoever there is a project window as soon as the
project
> is
> > > > open!
> > > > Sorry... I am very
... read more »
|
| Sun, 15 May 2005 20:44:25 GMT |
|
|
|
Ronald Dodg
#9 / 19
|
Project Window Activation from Resource Sheet if any When I mentioned linked resources, that's coming from having to go through the Project side with the menu selections, Tools>Resources>Share Resources..., and that is how the various people in our Customer Service department link the resources (projects as you call it) to the Project (pool as you call it). Again, sorry if I don't know *ALL* of the correct terminology for Project. I don't mind so much the fact that you suggested for me to learn more about Project of which that's a fair statement, but to imply that I should know all of the proper terminology right from the get go, that's asking a bit much, I think. Let me ask you a question. Did you know everything about Project, when you first started working with Project? The one advantage I have when it comes to programs that are new to me, I seem to have a natural ability to be able to find most of the things that I want to do with relatively low resistance (if any) as compared to most people, and I thank God for having that ability/gift. If I was to respond to a person who is new to the program that I am helping
them out with, the way you did to me, that person most likely will not come
back to me for additional help. As a matter of fact, most people don't know
the Computer Jargon language, and they mostly likely really don't care
either cause it's well over their head. Therefore, it takes a softer
approach and have to put it into layman's terms. Now does this mean that
you should take it down to layman's term for everyone, I don't think so
cause you have to get to know at the level they are at, and then bring the
terminology down to that level so as you don't end up insulting their
intelligence. I'm not saying that this is an easy task to do all the time,
but keeping this in mind, it usually does help. This is especially true for
those that takes a first crack at it, cause they are most likely going to be
very critical early on with different objectives, and if they find that it's
too tough to learn or use for what they want to do within the time they
have, they aren't going to mess with it.
We not too long ago dropped a Manufactuiring DB system vendor for that very
reason. Their DB system was easy for operators to use, but when it came
time to pull the data out of the system for reporting purposes, there were a
lot of issues that needed to be addressed cause the vendor programmed into
it some bad assumptions. I had pointed them out to one of the programmers,
and he basically looked at me as if, I was just a little peon who didn't
know much about computers, and told me that was too much work. My computer
experience was telling me otherwise that it was relatively little work given
there were already some things in place that would have helped the task out.
That convo took place in Feb of 1999, 2 months after I had taken over the
Production Reporting System of what the plant had at that time. I
understand that I don't know their code, but still even without that
knowledge, my computer experience was telling me otherwise under the
assumption as if they are good programmers.
Given these different issues, I was about the only person that even
attempted to address them out of the roughly 600 employees in the company,
and I'm not even in the IT department. One by one for the 7 different
plants that we have, they were dropping the use of the program cause it was
too hard to use the data administratively. The plant I'm at was the last
one to drop the use of it, and that's only cause I had work arounds in place
and automated to address the different issues of which our other
manufacturing plant didn't want to use my work arounds since they had
slightly different situation in place (5 of the 7 plants are assembly plants
which uses a whole total different set of assumptions). The cost of it for
just the one plant to use was not economically sound, so I had created my
own Production Reporting System and it's now in full operations. Granted, I
didn't have much time to create it (less than 1 month), but I got it at
least to the point that it was workable, though still had to deal with
issues after that initial period. My boss and I had trained all other
operators how to use the program of which a lot of them were impressed with
what I had done in such short time. But then I did it cause I didn't want
to get stuck doing all of the data entry by hand from paper logs. After my
experience of data entry working at the IRS, I'm like, "never again, if I
can help it." We dropped that vendor in June of 2002, so as you can see,
customer service quality is just as important as the product.
--
Ronald R Dodge, Jr
Production Statistician
Master MOUS 2000
Quote: > OK, OK, sorry if I was a bit harsh. > Still, it would make your questions much more easier to read and to reply to > shoudl you switch to Project's vocabulary. > For instance, you write: > "if there's like more than 30 linked resources to a single project file,
we
> start running into issues with opening the project file"
> There is no such thing as linked resources to a project file. I think you
> mean projects linked to a resource pool, so I think you mean
> "if there's like more than 30 projects linked to a single resource pool,
we
> start running into issues with opening the pool,"
> Then I would be encouraged to go on reading, I do not have to guess what
you
> mean.
> Just a suggestion meant to help you, when your questions are in Project
> language, more people will be motib-vated to help you.
> Greetings,
> --
> Jan De Messemaeker
> Microsoft Project Most Valuable Professional
> Project Management Consultancy
> Prom+ade BVBA
> 32-495-300 620
> > I admit, I am relatively new to Project Objects in VBA. I have taken up
a
> 2
> > day training course paid by the company in Project 98, so I do know some
> > things about it, but as the old saying goes, it takes experience to know
> how
> > to really work it. I am not new to VBA in general though. I have
worked
> in
> > Excel VBA for quite a bit (going on 4 years now), and I have taken on
some
> > training courses in VB6 of which there's a lot of similarities in
general.
> > BTW, I did get my VBA working properly for what I was attempting to do.
> It
> > was a bit of a trick, and that's given the fact that the code may not
> > necessarily know the name of the resource file(s) that are being opened,
> at
> > least not in VBA. What I had done was used the InStr function for each
> > window in Application.Windows.Caption (assuming that the file did open
of
> > which if it couldn't open with the third option, it would skip the
project
> > and go to the next project file) and look for the "Project" name in it.
> > This Application.Windows through me off for a loop cause in Excel to set
> > window settings on a workbook, you use
> > Application.Workbooks("Book1.xls").Windows.<Property>, but for the same
> > property or set of properties in Project, I had to use
> > Application.Windows.<Property>
> > There were a lot of issues that I dealt with in Project/Excel to get
them
> 2
> > talking to each other, so as I don't have to do the tasks for 20
different
> > Project Files. We would have less, but us as a company has learned, if
> > there's like more than 30 linked resources to a single project file, we
> > start running into issues with opening the project file, so that's the
> > biggest reason why all of the tasks are being filtered, then copied in
> > Project, and then pasted into Excel.
> > I'm about to run a final test this evening, but will have to wait til
all
> > office personnel have left for the day so as I can be sure that no one
is
> > making changes to the impacted files that I'm testing my code on.
> > Issues addressed:
> > Getting the appropriate windows (explained above via the
> Application.Windows
> > rather than Application.Projects().Windows
> > Making sure the Object Variable is only set to a Project 98 application
> when
> > needed (put in a 5 second sleep time to give the code a chance to set
the
> > variable to nothing cause it worked fine when ran each loop
individually,
> > but skipped every other file when ran all at once)
> > Not saving project file since the code is only meant to copy and paste
> > between Project and Excel (This was resolved by using FileExit
> > (pjDoNotSave))
> > When using the PasteSpecial (Worksheet Object) in Excel, and had it
> > specified to do in "Microsoft Excel 8.0 Object", it did in that format
and
> > in "Microsoft Project 8.0 Project Object" format. (Had to use
> > Workbooks(<WorkbookSpecName>).Worksheets(<SheetName>).Pictures to remove
> the
> > Project Object paste)
> > The issues above were the main issues that I had to do some hunting
around
> > to resolve.
> > Remaining Issue that happens both by hand and in automation:
> > When using the PasteSpecial (Worksheet Object) in Excel to paste Project
> 98
> > data into Excel at the specified location (as has been set by the active
> > cell), get a general error message "File not found" with no error number
> or
> > anything.
> > ADDITIONAL INFO ABOUT MY KNOWLEDGE OF VBA IN GENERAL AND IN EXCEL
> > Given I am relatively new to Project's Component Object Model (COM), it
> did
> > take me longer to resolve these issues than it would have been, if I
knew
> > them pretty much inside out like I do with Excel Objects. On the other
> > hand, given I do know how to look for certain things via the Watch,
Local,
> > and Intermediate Windows, understand the use of On Error statements,
> > Variable declarations, the difference of Sub vs Function along with the
> uses
> > of both, and how to read through help files and
> msdn.microsoft.com/library,
> > all of these things has helped me resolve the issues.
... read more »
|
| Sun, 15 May 2005 23:15:34 GMT |
|
|
|
Jack D
#10 / 19
|
Project Window Activation from Resource Sheet if any Ronald, Jan doesn't work for Microsoft.
He is not paid by Microsoft.
He is helping you for free because he is a nice guy.
I concur with Jan that you will do much better if you study project and the
project object model.
It is significantly different from the excel cell and worksheet based model
so dealing with window names and the like is not the most effective way to
do things.
-Jack Dahlgren
+++++++++++++++++++
Quote: > can help it." We dropped that vendor in June of 2002, so as you can see, > customer service quality is just as important as the product. > --
> Ronald R Dodge, Jr
> Production Statistician
> Master MOUS 2000
|
| Sun, 22 May 2005 10:42:21 GMT |
|
|
|
Ronald Dodg
#11 / 19
|
Project Window Activation from Resource Sheet if any I understand the points you make out of which they are valid points. None of us gets paid by MS. Even the part that Jan mentioned about learning more of how Project works, that I totally agree with, but to go on and imply that I have to know how project works in every aspect before I post a question to the newsgroup, I don't think that's being fair. Why would I even post a question to the NG if I knew how Project works in every aspect? Secondly, yes, Project's COMs (Component Object Model) are very different
from Excel's COMs, but does that mean VBA works differently in Project from
Excel in general? No. The general stuff that you use in Excel is the same
as what you use in Projects. Objects are quite different, but the methods
for finding out what to use and the methods of debugging in VBA is not
different between the 2. You still use the 3 debugging windows (Watch,
Immediate, and Local) along with the other debugging tools that's part of
VBA. I will go on to say, understanding how Project works for the most part
will help out in the process of finding out which objects to use and how to
use them, but does that mean it's the only way, obviously not. Sorry if I
seem rather harsh in my critisms about this, but I just hate it when someone
tries to tell me that I have to know something pretty much inside out before
I can post a question or that there's only one way of doing things.
The Windows thing, yes, I would tend to think there's a better way of doing
it, but if it's not showing up of how to do it in a better way, then I'm
going to go with that, provided that it works the way it suppose to work.
Again, you are right with this point, learning how Project COMs works would
give a much higher chance that I would know what to use in place of it. My
last point was the fact that cause I haven't worked with Project COMs all
that much, it is going to take time to learn how the COMs works in Project.
It's not like I'm going to just understand how it all works within an hour's
time or even within a single day's time. Using the VBA tools helps in that
process, but again, it's going to take longer than just a 24 hour period.
Sometimes, learning how things works means turning to those that already
knows how it works and ask them the question(s) to help further understand
how it works, like in this case, I posed the question so as I could get a
better feel for what all I would need to do in Project, but as I found with
this question, I basically had to do all of the digging myself as I didn't
get much help if any, which leads up to another thing about me, I'm not just
going to wait around for an answer if I don't get one within the time period
expected, if anyone has one (normally, it would be within a few hours, but
it could be a few days, especially if it falls around weekend and/or
holidays). In that case, I am going to assume one of 4 things:
it can't be done thus means find another way,
it could be done, but is rather technical to the point that most doesn't
know how if any does which means further R&D on my part,
maybe it's such a rare occurence that they may not have ran into the
situation before (I.e. the 'File not found' situation that I ran into, come
to find out, it looks like it's a bug based on article Q192405 on MSKB with
a similar type deal between copying in Access and pasting into Excel 97), or
maybe I just needed to reword my question in a different manner/format and
possibly provide more details without giving out confidential information.
I don't know about you, but I tend to use the NGs more or less as a learning
tool and to help others learn as I see things that they are having
difficulty understanding and I know how it works. Isn't that was NGs are
for (at least one of the reasons)? For us to learn form each other and
share our knowledge to the community? Sometimes when the person ask a
question, it may not be quite so understandable cause they don't know all of
the technically correct terms. Therefore, you do have to be able to know
how to break it down into parts and try to help them out, if you can. In
those cases, it's similar to those math story problems that we had back in
our elementary school years in the sense that you have to break it down to
parts before you work out the problem.
--
Ronald R Dodge, Jr
Production Statistician
Master MOUS 2000
Quote: > Ronald, > Jan doesn't work for Microsoft.
> He is not paid by Microsoft.
> He is helping you for free because he is a nice guy.
> I concur with Jan that you will do much better if you study project and
the
> project object model.
> It is significantly different from the excel cell and worksheet based
model
> so dealing with window names and the like is not the most effective way to
> do things.
> -Jack Dahlgren
> +++++++++++++++++++
> > can help it." We dropped that vendor in June of 2002, so as you can
see,
> > customer service quality is just as important as the product.
> > --
> > Ronald R Dodge, Jr
> > Production Statistician
> > Master MOUS 2000
|
| Mon, 23 May 2005 00:40:43 GMT |
|
|
|
Mike Gle
#12 / 19
|
Project Window Activation from Resource Sheet if any Hi Ronald, Methinks you're being a bit sensitive! I too had difficulty in
understanding your problem and I hesitated long enough for Jan to jump in to
help first!
Jan said helpfully in order to understand you problem:
------------------------------
"if there's like more than 30 linked resources to a single project file, we
start running into issues with opening the project file"
There is no such thing as linked resources to a project file. I think you
mean projects linked to a resource pool, so I think you mean
"if there's like more than 30 projects linked to a single resource pool, we
start running into issues with opening the pool,"
Then I would be encouraged to go on reading, I do not have to guess what you
mean.
---------------------------
You followed up with:
-----------
When I mentioned linked resources, that's coming from having to go through
the Project side with the menu selections, Tools>Resources>Share
Resources...,
---------------------
which demonstrated to me that you KNEW about shared resources and resource
pools. So why not use the correct terminology in the first place - we
cannot be expected to read minds, and I think Jan did an excellent job of
trying! And certainly you shouldn't interpolate :
--------
but to go on and imply that
I have to know how project works in every aspect before I post a question to
the newsgroup, I don't think that's being fair.
-------------
I believe you're being unfair to Jan.
However, That being said, all the MVPs and others who contribute here are
trying to help - so let's drop this line of discussion now.
Have you any other questions we can help you with?
Mike Glen
Project MVP
|
| Mon, 23 May 2005 01:55:37 GMT |
|
|
|
Ronald Dodg
#13 / 19
|
Project Window Activation from Resource Sheet if any Thank you Mike for your input. I don't really have anything else that I need help with at this point of time in Project. I would like to point out where I'm coming from though as I may have went a bit too far with Jan's quote: -----------------------------------------------------------------------
But finally, if you really want to wortk in Project through VBA, DO LEARN
SOMETHING ABOUT PROJECT.
What is a project, a view, a resource pool, a sharer...
If not you will have more questions than answers every step of the way!
-----------------------------------------------------------------------
But then again, which way we start out learning a program also impacts what
we know and don't know. Granted, I had a 2 day training course on Project
from Executrain, and maybe I didn't catch that particular term. On the
other hand, most of the time when I'm learning a program, I learn either
from someone showing me how they do it (about 5% of the time) (which was
done in this case as I showed with the Linked Resources example or what you
all call resource pool) or I learn it on my own (about 90% of the time), but
cause I see it done that way or I may have figured it out that way by
playing around with the different options and features, does that mean I may
necessarily know the correct terms? I would hardly think so. It's just
like of someone didn't know what the object was when it pasted a "Microsoft
Project 8.0 Project Object" into an Excel worksheet, would they think of it
being a Shape Object on the Worksheet Object, just cause they did the paste
by hand? Well the same applies here. I didn't know that what I was calling
as linked resources was really called resource pools. Just as there are
different ways of doing things, there's also different ways of learning
something and which ever way that is choosen is going to determine what is
known and what may not be known.
About 90% of my knowledge with the various computer things that I have
learned has been self taught with the remaining 10% from other resources.
Now lately, that percentage rate has been somewhat reversing a bit due to
the training that I been getting and paid for out of my own hard earned
money, but still a good majority of the stuff I learn has still been on my
own playing around with the various programs and languages.
With me in the business of developing good and sound business solutions
within the information system (IS) structure that is in place, I have to be
able to code to help make the processes easier to use and less cumbersome.
That's one reason why I have to be on the constant alert of what's out
there, what may get thrown at me, and what's the quickest way to learn about
something (keeping cost in mind) and get it to work for their needs.
--
Ronald R Dodge, Jr
Production Statistician
Master MOUS 2000
Quote: > Hi Ronald, > Methinks you're being a bit sensitive! I too had difficulty in
> understanding your problem and I hesitated long enough for Jan to jump in
to
> help first!
> Jan said helpfully in order to understand you problem:
> ------------------------------
> "if there's like more than 30 linked resources to a single project file,
we
> start running into issues with opening the project file"
> There is no such thing as linked resources to a project file. I think you
> mean projects linked to a resource pool, so I think you mean
> "if there's like more than 30 projects linked to a single resource pool,
we
> start running into issues with opening the pool,"
> Then I would be encouraged to go on reading, I do not have to guess what
you
> mean.
> ---------------------------
> You followed up with:
> -----------
> When I mentioned linked resources, that's coming from having to go through
> the Project side with the menu selections, Tools>Resources>Share
> Resources...,
> ---------------------
> which demonstrated to me that you KNEW about shared resources and resource
> pools. So why not use the correct terminology in the first place - we
> cannot be expected to read minds, and I think Jan did an excellent job of
> trying! And certainly you shouldn't interpolate :
> --------
> but to go on and imply that
> I have to know how project works in every aspect before I post a question
to
> the newsgroup, I don't think that's being fair.
> -------------
> I believe you're being unfair to Jan.
> However, That being said, all the MVPs and others who contribute here are
> trying to help - so let's drop this line of discussion now.
> Have you any other questions we can help you with?
> Mike Glen
> Project MVP
|
| Mon, 23 May 2005 02:47:40 GMT |
|
|
|
Ronald Dodg
#14 / 19
|
Project Window Activation from Resource Sheet if any Correction on my part, when I mentioned resource pools, I should has said projects with a single resource pool. BTW, that can be rather confusing, having to call the linked resources as projects, and then have a window with the name of ["Project" & #] that gathers all the data from each of the projects within the resource pool and show the data in the graph of how the user wants to see it and/or in the table format as the user wants to see it in. By having both called "project", it would then lead up to the question, which project do you mean, the window "Project" or the resource project? --
Ronald R Dodge, Jr
Production Statistician
Master MOUS 2000
Quote: > Thank you Mike for your input. I don't really have anything else that I > need help with at this point of time in Project. I would like to point out > where I'm coming from though as I may have went a bit too far with Jan's > quote: > -----------------------------------------------------------------------
> But finally, if you really want to wortk in Project through VBA, DO LEARN
> SOMETHING ABOUT PROJECT.
> What is a project, a view, a resource pool, a sharer...
> If not you will have more questions than answers every step of the way!
> -----------------------------------------------------------------------
> But then again, which way we start out learning a program also impacts
what
> we know and don't know. Granted, I had a 2 day training course on Project
> from Executrain, and maybe I didn't catch that particular term. On the
> other hand, most of the time when I'm learning a program, I learn either
> from someone showing me how they do it (about 5% of the time) (which was
> done in this case as I showed with the Linked Resources example or what
you
> all call resource pool) or I learn it on my own (about 90% of the time),
but
> cause I see it done that way or I may have figured it out that way by
> playing around with the different options and features, does that mean I
may
> necessarily know the correct terms? I would hardly think so. It's just
> like of someone didn't know what the object was when it pasted a
"Microsoft
> Project 8.0 Project Object" into an Excel worksheet, would they think of
it
> being a Shape Object on the Worksheet Object, just cause they did the
paste
> by hand? Well the same applies here. I didn't know that what I was
calling
> as linked resources was really called resource pools. Just as there are
> different ways of doing things, there's also different ways of learning
> something and which ever way that is choosen is going to determine what is
> known and what may not be known.
> About 90% of my knowledge with the various computer things that I have
> learned has been self taught with the remaining 10% from other resources.
> Now lately, that percentage rate has been somewhat reversing a bit due to
> the training that I been getting and paid for out of my own hard earned
> money, but still a good majority of the stuff I learn has still been on my
> own playing around with the various programs and languages.
> With me in the business of developing good and sound business solutions
> within the information system (IS) structure that is in place, I have to
be
> able to code to help make the processes easier to use and less cumbersome.
> That's one reason why I have to be on the constant alert of what's out
> there, what may get thrown at me, and what's the quickest way to learn
about
> something (keeping cost in mind) and get it to work for their needs.
> --
> Ronald R Dodge, Jr
> Production Statistician
> Master MOUS 2000
> > Hi Ronald,
> > Methinks you're being a bit sensitive! I too had difficulty in
> > understanding your problem and I hesitated long enough for Jan to jump
in
> to
> > help first!
> > Jan said helpfully in order to understand you problem:
> > ------------------------------
> > "if there's like more than 30 linked resources to a single project file,
> we
> > start running into issues with opening the project file"
> > There is no such thing as linked resources to a project file. I think
you
> > mean projects linked to a resource pool, so I think you mean
> > "if there's like more than 30 projects linked to a single resource pool,
> we
> > start running into issues with opening the pool,"
> > Then I would be encouraged to go on reading, I do not have to guess what
> you
> > mean.
> > ---------------------------
> > You followed up with:
> > -----------
> > When I mentioned linked resources, that's coming from having to go
through
> > the Project side with the menu selections, Tools>Resources>Share
> > Resources...,
> > ---------------------
> > which demonstrated to me that you KNEW about shared resources and
resource
> > pools. So why not use the correct terminology in the first place - we
> > cannot be expected to read minds, and I think Jan did an excellent job
of
> > trying! And certainly you shouldn't interpolate :
> > --------
> > but to go on and imply that
> > I have to know how project works in every aspect before I post a
question
> to
> > the newsgroup, I don't think that's being fair.
> > -------------
> > I believe you're being unfair to Jan.
> > However, That being said, all the MVPs and others who contribute here
are
> > trying to help - so let's drop this line of discussion now.
> > Have you any other questions we can help you with?
> > Mike Glen
> > Project MVP
|
| Mon, 23 May 2005 03:12:09 GMT |
|
|
|
Mike Gle
#15 / 19
|
Project Window Activation from Resource Sheet if any OK, Ronald. Good luck then! Mike Glen
Project MVP
Quote: > Thank you Mike for your input. I don't really have anything else that I
> need help with at this point of time in Project.
|
| Mon, 23 May 2005 05:19:08 GMT |
|
| |
Page 1 of 2
|
[ 19 post ] |
|
Go to page:
[1]
[2] |
|
