VBE (visual Basic Editor) variable

[Hellboy]

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 shows 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 are: 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 ?


That is my main problem. there is 2 others.

- The button sometimes only works once
- I cant come back on the same place before i click my button

Any help, critics, amilioration at all, will be appriciated !

Thank's

Philippe


+-------------------------------------------------------------------+
|Filename: vba_to_xld.zip |
|Download: http://www.excelforum.com/attachment.php?postid=3585 |
+-------------------------------------------------------------------+

 

[Tom Ogilvy]

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

Should give you some insights into how to modify the code in the xla.

 

[Hellboy]

Hi

Thanks for your reply. You gave me a good reference for my question and
i did some modifications base on it. But i feel that my xla file will
not pass the reliability test. I am not a vb programmer, so class
module, or objet or collection, are think's that i dont fully
undurstand.

If you feel that you can improve or teel me how to do so and have the
time to do so, i am attaching my new file with this post.

Thanks again.

Philippe


+-------------------------------------------------------------------+
|Filename: vba_to_xld.zip |
|Download: http://www.excelforum.com/attachment.php?postid=3589 |
+-------------------------------------------------------------------+