?
Solved

Application.VBE.VBProjects(i)

Posted on 1998-10-22
2
Medium Priority
?
1,973 Views
Last Modified: 2012-05-04
Application.VBE.VBProjects(3) gives the third vbaproject
but order may change. I have a project called
VBAProject(proj.xla), since it is third one for now
it works, but how can I use the name to get this project.
I tried
Application.VBE.VBProjects(proj.xla) and
Application.VBE.VBProjects("proj.xla") did not work.
I used item name to verify, but all names gives VBAProject
not a specific name. How??? thanks
0
Comment
Question by:has
2 Comments
 
LVL 3

Accepted Solution

by:
frazer earned 400 total points
ID: 1614119
hi,

You are very close omit the .xla and it should work fine.

eg

Sub test()
    MsgBox Application.VBE.VBProjects("funcres").Name
End Sub

Regards

Frazer
0
 

Author Comment

by:has
ID: 1614120
VBAProject(proj.xla), shows name as VBAProject
so I changed it to proj, then it shows
proj(proj.xla), now I can use Application.VBE.VBProjects("proj")
but nor because of the file proj.xla, but project name is proj.
there should be a way of getting it directly from the file name
thanks alot for the help. but if you have a comment, please
do send it, I need to undrsand this better may be.
0

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft's Excel has many features that most people will never need nor take advantage of.  Conditional formatting is one feature that you may find a necessity once you start using it.
New style of hardware planning for Microsoft Exchange server.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

862 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question