Hey guys

I need to list all of my open projects. What is the code
for this?


Thank you

Todd Huttenstine

http://www.cpearson.com/excel/vbe.htm

should give you the basics.

--
Regards,
Tom Ogilvy


"Todd Huttenstine" wrote in message
...
Hey guys

I need to list all of my open projects. What is the code
for this?


Thank you

Todd Huttenstine

This does not tell how to list all the open projects.




-----Original Message-----
http://www.cpearson.com/excel/vbe.htm

should give you the basics.

--
Regards,
Tom Ogilvy


"Todd Huttenstine"
wrote in message
...
Hey guys

I need to list all of my open projects. What is the
code
for this?


Thank you

Todd Huttenstine


.

You must have missed it:

Before using these procedures, you'll need to set a reference in VBA to the
VBA Extensibility library. In the VBA editor, go to the Tools menu, choose
the References item, and put a check next to "Microsoft Visual Basic For
Applications Extensibility" library. This enables VBA to find the
definitions of these objects.


After you create the reference, go to the object browse and restrict the
search to VBIDE

search on Project

at the bottom you will see

VBE VBE Projects

click on that and hit F1

from help:

Returns the VBProjects collection, which represents all of the projects
currently open in the Visual Basic IDE.



--

Regards,

Tom Ogilvy




"Todd Huttenstine" wrote in message
...
This does not tell how to list all the open projects.




-----Original Message-----
http://www.cpearson.com/excel/vbe.htm

should give you the basics.

--
Regards,
Tom Ogilvy


"Todd Huttenstine"
wrote in message
...
Hey guys

I need to list all of my open projects. What is the
code
for this?


Thank you

Todd Huttenstine


.

Todd,

Try something like

Dim VBProj As VBIDE.VBProject
For Each VBProj In Application.VBE.VBProjects
Debug.Print VBProj.Name
Next VBProj


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"Todd Huttenstine" wrote in
message ...
Hey guys

I need to list all of my open projects. What is the code
for this?


Thank you

Todd Huttenstine