Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating Macro code dyanamically
Hi Shibuup,
See Chip Pearson's page on programming to the VBE at: http://www.cpearson.com/excel/vbe.htm --- Regards, Norman "shibuup" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can anyone help with the code for creating a aut print macro... | Excel Discussion (Misc queries) | |||
Creating a code for a macro | Excel Discussion (Misc queries) | |||
Creating Macro or Code Help? | Excel Worksheet Functions | |||
Creating macro code in Excel | Excel Programming |