how to paste macro to a newly created file using vba

N

noobi

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to copy/paste macro to a newly created file using vba 2
code to attach a macro to a newly created worksheet 2
Search macro for greater than 100000 on multiple CSV files 1
VBA code for pasting links -- modifying RDB code for summary workbook 11
Macro to open file and copy information from worksheet 1
How do I direct a macro to a newly opened workbook 2
Pasting a cell into bookmarked table from excel vba 1
Copy VBA code into a workbook created by a macro 11

Top