VBE( Visual Basic Application)
 

Hi

With an XLA file that load when Excel open, there is a new button in the vbe
standard bar menu that appears. With the click of that button it pops up a
userform that contain a TextBox that shows all the code that is present in
the vbe XLA file. The problem that I have is that it always shoes the code
of only that XLA file. But, i would like to be able to see the codes of
other vbproject. Meaning, that the one that i am seeing a the screen, is the
one that i would like to list when i click on my button.
So my questions a How, When, Where can I get the information that I need
to use the ThisWorkbook.name of the window that I am looking at and pass it
some how to my XLA project ?

Thank's

Philippe

VBE( Visual Basic Application)
 

Use ActiveWorkbook instead of ThisWorkbook.


"phil" wrote:

Hi

With an XLA file that load when Excel open, there is a new button in the vbe
standard bar menu that appears. With the click of that button it pops up a
userform that contain a TextBox that shows all the code that is present in
the vbe XLA file. The problem that I have is that it always shoes the code
of only that XLA file. But, i would like to be able to see the codes of
other vbproject. Meaning, that the one that i am seeing a the screen, is the
one that i would like to list when i click on my button.
So my questions a How, When, Where can I get the information that I need
to use the ThisWorkbook.name of the window that I am looking at and pass it
some how to my XLA project ?

Thank's

Philippe