Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Jun 2003
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    script editor folders (Excel 2002 VBA)

    Look at the picture in the attachment.

    I am writing a program in vb6 that opens up the script editor of a template and can read what is in the project. By looking at the attachment you can see that there are three folders in there. But for instance, if I wanted to only open up ewpe2, how would I go about knowing if it is in there and which of the three are ewpe2.

  2. #2
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    Brussels, Brussel, Belgium
    Posts
    159
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: script editor folders (Excel 2002 VBA)

    hi,

    your question is not very clear to me. however, once you got a reference to excel's application object, you can explore this tree with for instance

    application.vbe.vbprojects.count
    application.VBE.VBProjects(1).Name

    ...

    greetings,

Posting Permissions

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