Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to paste macro to a newly created file using vba
Hello,
I have a workbook with numbers of macros - one of it translate data numbers into text "in words". I've created a function which after fullfilling datasheet, is copying it into a new file. And now I have a problem, because in a new workbook there is no macro and of course there isn't my function, so the datasheet doesn't works good. I don't want to copy this function manually - I'd like to make it more automatic /during copying data into a new workbook/. Unfortunatelly I don't know how to do it. If somebody knows how to do it, Please - show me an example. thx, Maleo |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to paste macro to a newly created file using vba
hi
see this site.. http://cpearson.com/excel/vbe.aspx it has detailed code on how to do that plus other things to. read down. make note of warning!!! Regards FSt1 "noobi" wrote: Hello, I have a workbook with numbers of macros - one of it translate data numbers into text "in words". I've created a function which after fullfilling datasheet, is copying it into a new file. And now I have a problem, because in a new workbook there is no macro and of course there isn't my function, so the datasheet doesn't works good. I don't want to copy this function manually - I'd like to make it more automatic /during copying data into a new workbook/. Unfortunatelly I don't know how to do it. If somebody knows how to do it, Please - show me an example. thx, Maleo |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
using a cell value to name a newly created workbook | Excel Discussion (Misc queries) | |||
Can't find newly created userform | Excel Programming | |||
Referencing a newly created worksheet | Excel Worksheet Functions | |||
Add list to newly created menu | Excel Discussion (Misc queries) | |||
add list to newly created menu | Excel Worksheet Functions |