Adding a description to an Excel Macro created by a script 1

[drlex]

Greetings, all.

I have a small problem that I cannot find a solution for - it is Friday afternoon and my google-fu is weak.

I am adding a macro to a spreadsheet by way of VB script, using the code

   Set xlmodule = objExcel.Workbooks(1).VBProject.VBComponents.Add(1) 
   xlmodule.CodeModule.AddFromString strCode
   Set xlmodule = Nothing

where strCode contains the macro. What I'd like to do is add a description that is visible to the user of the spreadsheet when they select the macro to run.
Do I need to add the description to the macro code in strCode or is there a VBComponents command I need to use?


Many thanks & happy Friday,
lex

soi la, soi carré

 

[xlbo]

Hi Lex - looks like its under application.macrooptions


Application.MacroOptions Macro:="MacroName", Description:="Description Here", ShortcutKey:=""

So if you know the name of the macro that's beeing created, you can add the description afterwards by the looks of it

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[drlex]

Geoff,
You're a National treasure - have a virtual pint! I can now skip home happily, knowing users will be less confused as a result.
Nice one, chap!
Lex

soi la, soi carré