Excel Macros
 

Is there a way to programatically list all embedded macros
in a particular workbook? I need to access a workbook
object and update a listbox with all available macros.
thanks.

Excel Macros
 

Matt,

Take a look at http://www.cpearson.com/excel/vbe.htm. There is enough code
there to show you how.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Matt" wrote in message
...
Is there a way to programatically list all embedded macros
in a particular workbook? I need to access a workbook
object and update a listbox with all available macros.
thanks.

Excel Macros
 

http://tinyurl.com/2opra

should provide some sample code.

For general information, see Chip Pearson's site on programming the VBE

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

basically you have to parse all the modules looking for Sub and Function and
extracting the name.

this assumes you don't want to just show the built in macro selection
dialog.

--
Regards,
Tom Ogilvy

Matt wrote in message
...
Is there a way to programatically list all embedded macros
in a particular workbook? I need to access a workbook
object and update a listbox with all available macros.
thanks.

Excel Macros
 

Hi Matt

Try Chip Pearson's page
I believe he have a example

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

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl



"Matt" wrote in message ...
Is there a way to programatically list all embedded macros
in a particular workbook? I need to access a workbook
object and update a listbox with all available macros.
thanks.