Solved

Application.VBE.VBProjects(i)

Posted on 1998-10-22
2
1,711 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 100 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Introduction It seems that at least a couple of times per month, I answer a question that requires automating Outlook from another Microsoft Office application, usually (although not always) to send one or more email messages.  For example: …
PaperPort has a feature called the "Send To Bar". It provides a convenient, drag-and-drop interface for using other installed software, such as Microsoft Office. However, this article shows that the latest Office 2016 apps (installed with an Office …
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
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 …

770 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