using vba to program vba???

Yes, right click the module in the VBA Prject Window and select export file. It will save as a file with BAS extension. Open the workbook where you want to import, open VBA and select File|Import File.

hth

Ja, Sorry i was a bit unclear. The problem is I want to use code to copy or write the function, not do it manually

Luke

I could be wrong but I dont think you can programatically do this. Why dont you save the macro in your personal.xls or as an add-in?

You can do it programmatically, but as Parry says, it'd be far easier to save it to your Personal macro workbook or as an add-in. For details of doing it in code, see-

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

The thing is, I have created a duty roster file which is now used in a number of workplaces by people who are wonderfull at pointing me at the problems, (it really is incredible, I test and test and test and find everything correct, and ecpecially one person can sit and do nothng and come across problems.), but have absolutely no Idea what they are doing. The program is so small the it can make duty rosters and do all the calculations for more than a year and still fit on a disk so that it can be transported. That is where the problem of a plug-in comes along. It cannot expect these people to save two files; i would first have to explain what a file is and that would take me too long. That is why I want this program to be self-sufficiënt. I have contemplated writing the entire thing in visual basic as all i do with excel is make use of the layout of the spreadsheet and otherwise try to turn everything I don't want to use off, but I had done so much in VBA that this was the easiëst way.

Luke

OK, check out Chip Pearson's site at the link above.

Tried it, and worked like a charm except that Norton Antivirus decided I was programming a virus or something. it kicked up saying it found bloodhound.ExcelMacro. Whatever it is, not programming and not using the therefore necessary references leaves a virus-scan blank and I cannot have other computers going berserk saying they found a virus, whether it is there or not.
Weird though, this virus scan pop-up. Has anyone else had this problem?? It seems to be directly related to the reference "Microsoft Visual Basic For Applications Extensibility 5.3"

Luke

I had a similar problem with "bloodhound" once when I copied and pasted code from a website. **** thing caused my fiel to be quarantined twice...
I got around it by typing everything in -- presumably the copy-paste from HTML left some invisible code traces that Norton sniffed out.
Hope this works for you

Denis

I was creating code from within code which is what i wanted to do. Now...I think i will go with what i had, using the function still in the parent workbook. I even tried putting the function on a worksheet and copying the worksheet, but functions on worksheet of course are not accepted. (I kwew that already, but had to try anyway)

Luke