I have a folder that contains several excel files, each excel file
contains a single macro.

Is it possible from a macro in another excel file to programmatically
determine the name of the macro in each of the files in the folder?

See Chip Pearson's site for programming the VBE.

http://www.cpearson.com/excel/VBE.aspx

Specifically "Listing all procedures in a Module"


Gord

On Sat, 5 May 2012 12:57:41 -0700 (PDT), John
wrote:

I have a folder that contains several excel files, each excel file
contains a single macro.

Is it possible from a macro in another excel file to programmatically
determine the name of the macro in each of the files in the folder?

Gord,

Thank you for the quick reply.

I was actually on that site earlier and saw that info but I can't get
it to work. I get the error:

User Defined Type not defined

Chip's method is clearly beyond my current level of VBA ability, I'm
probably not understanding some fine point of how VBA works.

In any case I was looking for something I could comprehend :-)

On May 5, 2:23*pm, Gord Dibben wrote:
See Chip Pearson's site for programming the VBE.

http://www.cpearson.com/excel/VBE.aspx

Specifically "Listing all procedures in a Module"

Gord

On Sat, 5 May 2012 12:57:41 -0700 (PDT), John
wrote:



I have a folder that contains several excel files, each excel file
contains a single macro.

Is it possible from a macro in another excel file to programmatically
determine the name of the macro in each of the files in the folder?- Hide quoted text -

- Show quoted text -

hi John,

did you added a réf. for Microsoft Visual Basic For Applications Extensibility 5.3


================================================== ================================================== ============
•First, you need to set an reference to the VBA Extensibililty library.
The library contains the definitions of the objects that make up the VBProject.
In the VBA editor, go the the Tools menu and choose References.
In that dialog, scroll down to and check the entry for Microsoft Visual Basic For Applications Extensibility 5.3.
If you do not set this reference, you will receive a User-defined type not defined compiler error.
================================================== ================================================== ============


--
isabelle



Le 2012-05-05 16:43, John a écrit :
Gord,

Thank you for the quick reply.

I was actually on that site earlier and saw that info but I can't get
it to work. I get the error:

User Defined Type not defined

Chip's method is clearly beyond my current level of VBA ability, I'm
probably not understanding some fine point of how VBA works.

In any case I was looking for something I could comprehend :-)

On May 5, 2:23 pm, Gord wrote:
See Chip Pearson's site for programming the VBE.

http://www.cpearson.com/excel/VBE.aspx

Specifically "Listing all procedures in a Module"

Gord

On Sat, 5 May 2012 12:57:41 -0700 (PDT),
wrote:



I have a folder that contains several excel files, each excel file
contains a single macro.

Is it possible from a macro in another excel file to programmatically
determine the name of the macro in each of the files in the folder?- Hide quoted text -

- Show quoted text -

Isabelle,

a réf. for Microsoft Visual Basic For Applications Extensibility 5.3

I have no idea what that is! Guess I need to do a little mroe
research.


On May 5, 2:54*pm, isabelle wrote:
hi John,

did you added a réf. for Microsoft Visual Basic For Applications Extensibility 5.3

================================================== =========================*======================== =============
•First, you need to set an reference to the VBA Extensibililty library.
The library contains the definitions of the objects that make up the VBProject.
In the VBA editor, go the the Tools menu and choose References.
In that dialog, scroll down to and check the entry for Microsoft Visual Basic For Applications Extensibility 5.3.
If you do not set this reference, you will receive a User-defined type not defined compiler error.
================================================== =========================*======================== =============

--
isabelle

Le 2012-05-05 16:43, John a écrit :



Gord,

Thank you for the quick reply.

I was actually on that site earlier and saw that info but I can't get
it to work. I get the error:

User Defined Type not defined

Chip's method is clearly beyond my current level of VBA ability, I'm
probably not understanding some fine point of how VBA works.

In any case I was looking for something I could comprehend :-)

On May 5, 2:23 pm, Gord *wrote:
See Chip Pearson's site for programming the VBE.

http://www.cpearson.com/excel/VBE.aspx

Specifically "Listing all procedures in a Module"

Gord

On Sat, 5 May 2012 12:57:41 -0700 (PDT),
wrote:

I have a folder that contains several excel files, each excel file
contains a single macro.

Is it possible from a macro in another excel file to programmatically
determine the name of the macro in each of the files in the folder?- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -

on the VBA window, go the the Tools menu and choose References.
In that dialog, scroll down to and check the entry for Microsoft Visual Basic For Applications Extensibility 5.3.
If you do not set this reference, you will receive a User-defined type not defined compiler error.

--
isabelle



Le 2012-05-05 17:01, John a écrit :
Isabelle,

a réf. for Microsoft Visual Basic For Applications Extensibility 5.3

I have no idea what that is! Guess I need to do a little mroe
research.


On May 5, 2:54 pm, wrote:
hi John,

did you added a réf. for Microsoft Visual Basic For Applications Extensibility 5.3

================================================== =========================*======================== =============
•First, you need to set an reference to the VBA Extensibililty library.
The library contains the definitions of the objects that make up the VBProject.
In the VBA editor, go the the Tools menu and choose References.
In that dialog, scroll down to and check the entry for Microsoft Visual Basic For Applications Extensibility 5.3.
If you do not set this reference, you will receive a User-defined type not defined compiler error.
================================================== =========================*======================== =============

also,

if you put "Option Explicit" at the top of the module, you need to declare all variables

--
isabelle



Le 2012-05-05 16:54, isabelle a écrit :
hi John,

did you added a réf. for Microsoft Visual Basic For Applications Extensibility 5.3


================================================== ================================================== ============
•First, you need to set an reference to the VBA Extensibililty library.
The library contains the definitions of the objects that make up the VBProject.
In the VBA editor, go the the Tools menu and choose References.
In that dialog, scroll down to and check the entry for Microsoft Visual Basic For Applications Extensibility 5.3.
If you do not set this reference, you will receive a User-defined type not defined compiler error.
================================================== ================================================== ============