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

[Tom Ogilvy]

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

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

--
Regards,
Tom Ogilvy

"Hellboy" <[email protected]> wrote in
message news:[email protected]...
>
> 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 |
> +-------------------------------------------------------------------+
>
> --
> Hellboy
> ------------------------------------------------------------------------
> Hellboy's Profile:
http://www.excelforum.com/member.php...o&userid=20879
> View this thread: http://www.excelforum.com/showthread...hreadid=385878
>

[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