Thread: Creating Macro code dyanamically

Is there is any solution that I could create a new worksheet and insert some
VBA code inside that worksheet and save it.

Eg.
1. Create a Download.xls
2. Insert the cotent of the Download.xls from Currently
executing Sheet.
3. Insert some Macro code into the Download.xls, (Which
could capture events and take actions)
et..

Is there any solution for Step3?

Hi Shibuup,

See Chip Pearson's page on programming to the VBE at:

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


---
Regards,
Norman



"shibuup" <shibuup@discussions.microsoft.com> wrote in message
news:79E4DC8C-0FBF-4983-B3D7-11F696041D61@microsoft.com...
> Is there is any solution that I could create a new worksheet and insert
> some
> VBA code inside that worksheet and save it.
>
> Eg.
> 1. Create a Download.xls
> 2. Insert the cotent of the Download.xls from Currently
> executing Sheet.
> 3. Insert some Macro code into the Download.xls, (Which
> could capture events and take actions)
> et..
>
> Is there any solution for Step3?