Consulting

Results 1 to 4 of 4

Thread: Solved: How can i get a list of Available References with a VBA Code?

  1. #1
    VBAX Tutor Erdin? E. Ka's Avatar
    Joined
    Sep 2006
    Location
    Bursa
    Posts
    264
    Location

    Solved: How can i get a list of Available References with a VBA Code?

    Hi everyone!

    I'am the newest member of this Forum. I like this Forum's format. I think that i will visit here everyday.


    I need a help about VBE Window | Tools | References | "Available References".

    How can i get a list to a worksheet of "Available References" with a VBA Code?

    Also, i want to get the Name, Location, Language, Version etc.. properties of all "Available References".

    Do you think this is possible?

    Thank you...
    Last edited by Erdin? E. Ka; 09-20-2006 at 06:42 PM.
    Erdin? E. Kara?am | Loves from Bursa city in Republic of T?rkiye

  2. #2
    Moderator VBAX Guru Ken Puls's Avatar
    Joined
    Aug 2004
    Location
    Nanaimo, BC, Canada
    Posts
    4,001
    Location
    Hi there,

    Welcome to VBAX!

    You could start with this knowledge base entry: Determine the File Path or GUID to a VBA Reference Library

    HTH,
    Ken Puls, CMA - Microsoft MVP (Excel)
    I hate it when my computer does what I tell it to, and not what I want it to.

    Learn how to use our KB tags! -||- Ken's Excel Website -||- Ken's Excel Forums -||- My Blog -||- Excel Training Calendar

    This is a shameless plug for my new book "RibbonX - Customizing the Office 2007 Ribbon". Find out more about it here!

    Help keep VBAX clean! Use the 'Thread Tools' menu to mark your own threads solved!





  3. #3
    VBAX Tutor Erdin? E. Ka's Avatar
    Joined
    Sep 2006
    Location
    Bursa
    Posts
    264
    Location

    I Feel So Good :)

    Quote Originally Posted by Ken Puls
    ... Welcome to VBAX! ...



    I have solved my problem with your help Dear Ken Puls, Thank You!
    Erdin? E. Kara?am | Loves from Bursa city in Republic of T?rkiye

  4. #4
    Moderator VBAX Guru Ken Puls's Avatar
    Joined
    Aug 2004
    Location
    Nanaimo, BC, Canada
    Posts
    4,001
    Location
    Great stuff! Would you like to try your hand at marking it solved? (See my signature.)

    Ken Puls, CMA - Microsoft MVP (Excel)
    I hate it when my computer does what I tell it to, and not what I want it to.

    Learn how to use our KB tags! -||- Ken's Excel Website -||- Ken's Excel Forums -||- My Blog -||- Excel Training Calendar

    This is a shameless plug for my new book "RibbonX - Customizing the Office 2007 Ribbon". Find out more about it here!

    Help keep VBAX clean! Use the 'Thread Tools' menu to mark your own threads solved!





Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •