Prev: Adding a decimal place
Next: Private Sub Workbook
From: Himanshu on 7 May 2010 12:46
I am trying to create a macro on the fly using vb code from an existing file,
and then run the Macro that was just created. Is there a way to find out the
name of a Macro programmatically so that I can pass it to the Application.Run
method?






From: JLGWhiz on 7 May 2010 13:25
Maybe:

myMacroName = Application.Dialogs(xlDialogMacroOptions).Show


"Himanshu" <Himanshu(a)discussions.microsoft.com> wrote in message
news:B140EF14-FF81-4E25-B1E2-8CD6EF813F56(a)microsoft.com...
>I am trying to create a macro on the fly using vb code from an existing
>file,
> and then run the Macro that was just created. Is there a way to find out
> the
> name of a Macro programmatically so that I can pass it to the
> Application.Run
> method?
>
>
>
>
>
>


 | 
Pages: 1
Prev: Adding a decimal place
Next: Private Sub Workbook