sandam
03-14-2005, 08:54 AM
I'd like to know if its possible to use formula's like you do in excel but with word tables and if said formulas can be created/executed using macros. It needs to be word tables however (I cant insert the excel sheet into the doc - not allowed to)
I ask this because I'm currently working on converting our old billing template from WordPerfect 9 into Word 2003 and the main problem is that after the old macro had run its calcs, you couldn't recalculate the bill values automatically if you changed them. If I can do it using formulas that will auto update then its all gravy. if not I'm stuck writing some hectic array code and fiddling with table end of cell chars again (I've been fiddling with this one around other easier template conversions and now its the main one I have to work on).
Thanks in advance
Andrew;?
I ask this because I'm currently working on converting our old billing template from WordPerfect 9 into Word 2003 and the main problem is that after the old macro had run its calcs, you couldn't recalculate the bill values automatically if you changed them. If I can do it using formulas that will auto update then its all gravy. if not I'm stuck writing some hectic array code and fiddling with table end of cell chars again (I've been fiddling with this one around other easier template conversions and now its the main one I have to work on).
Thanks in advance
Andrew;?