> i'm trying to write a macro to read all enterprise
> projects, accept all updates and save the files.  i'm
> stuck at step one with the macro however, where i need to
> set an object variable = to the collection of projects
> from the server.  i can't figure out what to reference to
> return the collection of projects.

> once i get that i plan to simply do a for next loop and
> open, accept all updates and save with the publish all
> argument.

> am i missing anything beyond the initial "getprojects" or
> whatever, call?

> thanks

>-----Original Message-----
>Try the VBA.Dir function using *.mpp for the first call
and just Dir there
>beyond.
>It can discover all the .mpp files in a certain directory.
>(See the help through the object browser)
>If you want to look in multiple directories you will need
a file giving teh
>addresses.
>HTH
>--
>Jan De Messemaeker
>Microsoft Project Most Valuable Professional
>Project Management Consultancy
>Prom+ade BVBA
>32-495-300 620


>> i'm trying to write a macro to read all enterprise
>> projects, accept all updates and save the files.  i'm
>> stuck at step one with the macro however, where i need
to
>> set an object variable = to the collection of projects
>> from the server.  i can't figure out what to reference
to
>> return the collection of projects.

>> once i get that i plan to simply do a for next loop and
>> open, accept all updates and save with the publish all
>> argument.

>> am i missing anything beyond the initial "getprojects"
or
>> whatever, call?

>> thanks

>.

> jan,

> thanks for the tip.  i'm familiar with that function and i
> could not figure out how to use it to get the projects
> from the project server database where, as you know, there
> are no dir's or .mpp's.  there must be a new function to
> do that.
> >-----Original Message-----
> >Try the VBA.Dir function using *.mpp for the first call
> and just Dir there
> >beyond.
> >It can discover all the .mpp files in a certain directory.
> >(See the help through the object browser)
> >If you want to look in multiple directories you will need
> a file giving teh
> >addresses.
> >HTH
> >--
> >Jan De Messemaeker
> >Microsoft Project Most Valuable Professional
> >Project Management Consultancy
> >Prom+ade BVBA
> >32-495-300 620


> >> i'm trying to write a macro to read all enterprise
> >> projects, accept all updates and save the files.  i'm
> >> stuck at step one with the macro however, where i need
> to
> >> set an object variable = to the collection of projects
> >> from the server.  i can't figure out what to reference
> to
> >> return the collection of projects.

> >> once i get that i plan to simply do a for next loop and
> >> open, accept all updates and save with the publish all
> >> argument.

> >> am i missing anything beyond the initial "getprojects"
> or
> >> whatever, call?

> >> thanks

> >.

>-----Original Message-----
>run following query

>SELECT MSP_PROJECTS.PROJ_NAME
>FROM MSP_PROJECTS;

>to get the project name list.

>======================================

>> jan,

>> thanks for the tip.  i'm familiar with that function
and i
>> could not figure out how to use it to get the projects
>> from the project server database where, as you know,
there
>> are no dir's or .mpp's.  there must be a new function to
>> do that.
>> >-----Original Message-----
>> >Try the VBA.Dir function using *.mpp for the first call
>> and just Dir there
>> >beyond.
>> >It can discover all the .mpp files in a certain
directory.
>> >(See the help through the object browser)
>> >If you want to look in multiple directories you will
need
>> a file giving teh
>> >addresses.
>> >HTH
>> >--
>> >Jan De Messemaeker
>> >Microsoft Project Most Valuable Professional
>> >Project Management Consultancy
>> >Prom+ade BVBA
>> >32-495-300 620


>> >> i'm trying to write a macro to read all enterprise
>> >> projects, accept all updates and save the files.  i'm
>> >> stuck at step one with the macro however, where i
need
>> to
>> >> set an object variable = to the collection of
projects
>> >> from the server.  i can't figure out what to
reference
>> to
>> >> return the collection of projects.

>> >> once i get that i plan to simply do a for next loop
and
>> >> open, accept all updates and save with the publish
all
>> >> argument.

>> >> am i missing anything beyond the

>> or
>> >> whatever, call?

>> >> thanks

>> >.

>.

> If I were working within a SQL Server application
> environment that would make sense.  However, I'm working
> from the a VBA environment on the Project Pro client.
> Actually, I already figured it out using Jan's suggestion
> below and using the server as the folder.

> Many thanks Jan.
> >-----Original Message-----
> >run following query

> >SELECT MSP_PROJECTS.PROJ_NAME
> >FROM MSP_PROJECTS;

> >to get the project name list.

> >======================================

> >> jan,

> >> thanks for the tip.  i'm familiar with that function
> and i
> >> could not figure out how to use it to get the projects
> >> from the project server database where, as you know,
> there
> >> are no dir's or .mpp's.  there must be a new function to
> >> do that.
> >> >-----Original Message-----
> >> >Try the VBA.Dir function using *.mpp for the first call
> >> and just Dir there
> >> >beyond.
> >> >It can discover all the .mpp files in a certain
> directory.
> >> >(See the help through the object browser)
> >> >If you want to look in multiple directories you will
> need
> >> a file giving teh
> >> >addresses.
> >> >HTH
> >> >--
> >> >Jan De Messemaeker
> >> >Microsoft Project Most Valuable Professional
> >> >Project Management Consultancy
> >> >Prom+ade BVBA
> >> >32-495-300 620


> >> >> i'm trying to write a macro to read all enterprise
> >> >> projects, accept all updates and save the files.  i'm
> >> >> stuck at step one with the macro however, where i
> need
> >> to
> >> >> set an object variable = to the collection of
> projects
> >> >> from the server.  i can't figure out what to
> reference
> >> to
> >> >> return the collection of projects.

> >> >> once i get that i plan to simply do a for next loop
> and
> >> >> open, accept all updates and save with the publish
> all
> >> >> argument.

> >> >> am i missing anything beyond the
> initial "getprojects"
> >> or
> >> >> whatever, call?

> >> >> thanks

> >> >.

> >.