SelectedVBComponent - get parent workbook`

[dmcgov]

i have the following:
Set objMyVbComp = Application.VBE.SelectedVBComponent

but if i check the ActiveWorkbook.Name, it is not the same.

how can i get the parent workbook from a selectedvbcomponent?

D

[JEC.]

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

[dmcgov]

JEC

Thanks for the contribution but it is not working in my code. let me show you:

Please Login or Register  to view this content.

does that make sense?

[JEC.]

So where does it error? Did you already try the second option?

[dmcgov]

a little more info

I am running this from the immediate window.

Please Login or Register  to view this content.

i place my cursor in "CodeVerTest.xlsm" somewhere and go back to the immediate window and press enter.

In your example, it returned "CodeVerData.xlsm" (which is the source of the procedure), which is wrong. It should have returned "CodeVerTest.xlsm".

Does that help?

[dmcgov]

is there a way to .Parent.Name up to the workbook name?

A little help please.

I did find that this works in that it gets the VBProject name. how can i use that to get the workbook name

Please Login or Register  to view this content.

[romperstomper]

Filename is the property for the file name of the workbook with the specified project in it.

[dmcgov]

Application.VBE.ActiveVBProject.VBComponents.Parent.Filename is the solution

[romperstomper]

Application.VBE.ActiveVBProject.VBComponents.Parent is just a very roundabout way of saying Application.VBE.ActiveVBProject

[dmcgov]

ah, another tidbit. wonderful. will make that edit to my code. btw, got a question on how to implement this in a userform. will post to a new thread.