Migrating Macro

[SpiroT]

Hi,

I'm thinking of writing a macro to help me with our migraion from MS
Professional 2002 to 2003. We want to try and save our users' "Option"
setting in 2002, and then restore them in 2003. Any suggestions?

 

[John]

Hi,

I'm thinking of writing a macro to help me with our migraion from MS
Professional 2002 to 2003. We want to try and save our users' "Option"
setting in 2002, and then restore them in 2003. Any suggestions?

SpiroT,
Reading the first line of your post looks like you think Project is a
big headache and I'm sure a lot of people would agree. (Proofreading
goes a long way.)

Some options are Global based and some are project specific. Probably
the best way to migrate options is to save the user's 2002 Global and
use it to overwrite the default Global that 2003 creates. Project
specific options don't need to be migrated because they reside with the
file, whether it is opened in 2002 or 2003.

Hope this helps.
John
Project MVP

 

[John]

SpiroT,
Reading the first line of your post looks like you think Project is a
big headache and I'm sure a lot of people would agree. (Proofreading
goes a long way.)

Some options are Global based and some are project specific. Probably
the best way to migrate options is to save the user's 2002 Global and
use it to overwrite the default Global that 2003 creates. Project
specific options don't need to be migrated because they reside with the
file, whether it is opened in 2002 or 2003.

Hope this helps.
John
Project MVP

SpiroT,
I forgot to include the precaution. I haven't tried substituting Globals
between 2002 and 2003 but the two versions are enough alike that it
shouldn't be a problem. However, just to be safe, be sure to save the
existing 2003 Global in a separate location so you can do a re-instate
it in case something goes awry.

John
Project MVP

 

[SpiroT]

Thanks Jphn,

I am particularly interested in capturing the global options settings that
are not part of project plans. I'm in the process of trying to write the
code to capture the information in each of the eight Option tabs. I started
with the Calendar, and now I am working on the View. Let me tell you, it is
as easy as I though it would be. Primarily because I can not find some of
the properties (eg., "Indent Name" is one example). There is enough
inconsitancies between the argument lists and the parameters/ propoerties to
drive you nut, so I think I am just going to quit trying.



I'm about to give up. You would think that they would allow you to cap

 

[John]

Thanks Jphn,

I am particularly interested in capturing the global options settings that
are not part of project plans. I'm in the process of trying to write the
code to capture the information in each of the eight Option tabs. I started
with the Calendar, and now I am working on the View. Let me tell you, it is
as easy as I though it would be. Primarily because I can not find some of
the properties (eg., "Indent Name" is one example). There is enough
inconsitancies between the argument lists and the parameters/ propoerties to
drive you nut, so I think I am just going to quit trying.



I'm about to give up. You would think that they would allow you to cap

Spiro,
So why not just replace the Global as I suggested? That is as easy as
1,2,3 and if it doesn't work, recovering the original is also easy.

One of the challenges with the Project object model, (and probably all
other application object models as well), is that some of the options
available through menus are not directly accessible through VBA. Finding
the font characteristics is a good example. And unfortunately there are
also errors or misinformation in the help files. But then if it were a
perfect world ..."

John

 

[SpiroT]

John... Your following paragraph was what I needed to hear.

One of the challenges with the Project object model, (and probably all
other application object models as well), is that some of the options
available through menus are not directly accessible through VBA. Finding
the font characteristics is a good example. And unfortunately there are
also errors or misinformation in the help files. But then if it were a
perfect world ..."

I was working on the View Options tab and I am discovering this too. I can
not seem to get acess to the properties of: Project Summary Task, Show
Outline Numbers and symbols, Indent Name, show Summary Task, Show External
Successors and Predecessors, etc. So, yes, I will follow your recommendation.

Thanks again,

 

[Jan De Messemaeker]

Hi SpiroT,

Well, IMHO John is right, it's really hell of a job to copy all options.
OTOH, I don't understand why after our correspondence on the subject you
still don't find the objects you mention.
It's not too difficult to find via the object browser that there is a
project property called
DisplayProjectSummaryTask
And with my small experience on global's objects I immediately tried
VBE.VBProjects(1).VBComponents(1).properties("DisplayProjectSummaryTask")
And it's there allright.

Greetings,