Read and list mpp files in a dialogue box with VBA 
Author Message
 Read and list mpp files in a dialogue box with VBA

Hello,

How can we read and list in a dialogue box (with VBA) all the projects file
names .mpp, their "Manager" and their "Status date" ?

Thanks

Grard Ducouret



Mon, 06 Dec 2004 21:33:33 GMT  
 Read and list mpp files in a dialogue box with VBA
If you want to do this for all .mpp files in a folder, use the Dir command
to list all .mpp files in a folder you nominate, then open each in turn and
read the Subject with the activeproject.BuiltinDocumentProperties method.

Get the status date using: activeproject.StatusDate

Add this data to a VBA UserForm by creating a  listbox.

--

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:
> Hello,

> How can we read and list in a dialogue box (with VBA) all the projects
file
> names .mpp, their "Manager" and their "Status date" ?

> Thanks

> Grard Ducouret



Sat, 11 Dec 2004 05:34:48 GMT  
 Read and list mpp files in a dialogue box with VBA
Hi Rod,
It works fine !
Thanks !

Grard



Quote:
> If you want to do this for all .mpp files in a folder, use the Dir command
> to list all .mpp files in a folder you nominate, then open each in turn
and
> read the Subject with the activeproject.BuiltinDocumentProperties method.

> Get the status date using: activeproject.StatusDate

> Add this data to a VBA UserForm by creating a  listbox.

> --

> 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



> > Hello,

> > How can we read and list in a dialogue box (with VBA) all the projects
> file
> > names .mpp, their "Manager" and their "Status date" ?

> > Thanks

> > Grard Ducouret



Sat, 11 Dec 2004 23:58:35 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. File list in MS common dialogue box

2. Reading file name from text box and/or File List Box

3. Please, please help - VB6 opening and reading a project mpp file

4. How to read mpp files ina directory ?

5. Reading an MPP 98 File

6. How to hide dialogue boxes using VBA

7. Help wanted with file list boxes and list boxes

8. List-Box for Files/Directory in Word-VBA

9. List-Box for Files/Directory in Word-VBA

10. How to read file contents into list box.

11. File Picker Dialogue Box

12. Problem with save file dialogue box in Excel

 

 
Powered by phpBB® Forum Software