Hello, nice forum here. I have a old Word .doc with some (2) macro in but it is not working any more. The .doc contains 3 tables 1 tabel for header (Table 1) 1 table for product pricing (Table 2 named POSITIONEN) name of prod., number of prod. and price per each which is calculated to a price per line 1 table which grep the colume where the price per line is calculated and sum it up Table1 has 4 colums Table2 has 6 colums Table3 has 2 colums The formula I use in Table3 B1 is: =SUM(POSITIONEN f:f) \# "#.##0,00 â¬;(#.##0,00 â¬) But all I get is !Syntaxfehler, : ##################### Thank you for your help. Bernhard Stillger, Germany
"Bernhard" wrote: > Hello, > > nice forum here. > > I have a old Word .doc with some (2) macro in but it is not working any more. > > The .doc contains 3 tables > 1 tabel for header (Table 1) > 1 table for product pricing (Table 2 named POSITIONEN) > name of prod., number of prod. and price per each > which is calculated to a price per line > 1 table which grep the colume where the price per line is calculated and sum > it up > > Table1 has 4 colums > Table2 has 6 colums > Table3 has 2 colums > > The formula I use in Table3 B1 is: > > =SUM(POSITIONEN f:f) \# "#.##0,00 â¬;(#.##0,00 â¬) > If it used to work and it doesn't anymore, I think you will agree that it means something has changed. Have you tried to change the formula? Have you modified Table 2 in such a way that the bookmark is not where it should be anymore? Have you changed Office/Windows Version? Have you changed the system language?