How to control that objects I have imported from Excel really upda Kristian 12/9/2008 12:55:01 PM Is there a way to really see that every element I have imported from an excel-sheet really works as it should in the word-document? -- Kristian

Re: How to control that objects I have imported from Excel really upda Cindy M. <C.Meister-C[ at ]hispeed.ch> 12/13/2008 10:59:14 AM Hi Kristian, [Quoted Text] > Is there a way to really see that every element I have imported from an > excel-sheet really works as it should in the word-document? > I don't understand your question. I understand the words, but don't know how to interpret them. Can you be more specific about what you're importing, how you're importing it, and what you want to check "really works as it should")? Also: in which version of Office? Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005) http://www.word.mvps.org This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-)

RE: How to control that objects I have imported from Excel really upda Kristian 12/14/2008 2:08:00 PM Thank you for your response. I am working in the office 2007. I have built a lot of statistics in excel. Elemenst from these statistics I shall use in a word-report ment to show how nnumbers have changed since the previous report made. I make one report for every three months, called quartal report. I made a test statsistics where I imported more than hundered different element connected from the excel work-sheet into the word-report. This functioned wery well. Each time I made a change in the excel- the change was to be seen in the report in world. But I would like to test that all elements really updates into the world-dokument so I can be sure that the report shall not contain element which not are up to date. I am from Norwy, hope you can understand what I try to explain and see more clearly now what is my whish. I can allso add that the elements I have plased into the word-doc. have the same format as the rest of the dok and is put into sentences. Therefore, you will not be able to see that hhe coccected element is from an excel-work sheet. Yours Kristian. -- Kristian Kristian skrev: [Quoted Text] > Is there a way to really see that every element I have imported from an > excel-sheet really works as it should in the word-document? > -- > Kristian

RE: How to control that objects I have imported from Excel really upda Cindy M. <C.Meister-C[ at ]hispeed.ch> 12/23/2008 8:43:29 AM Hi Kristian, I really can't think of any way to do what you ask, short of a macro that compares the result with the original. But if one were to go to all that trouble, then it would make just as much sense to use the macro to write the data to the document (and would probably be twice as fast). Since Word 2007 tends to suppress error messages on links, there is simply no way to determine whether a field has actually updated, short of comparing the result to the link source. One possibility that occurs to me, that could be simpler than coding a comparison, would be to include something, like that date, in the source. Build the new report document, check for the date and, if it's there everywhere, remove the date from the source then run the update again. [Quoted Text] > Thank you for your response. I am working in the office 2007. I have built a > lot of statistics in excel. Elemenst from these statistics I shall use in a > word-report ment to show how nnumbers have changed since the previous report > made. I make one report for every three months, called quartal report. I made > a test statsistics where I imported more than hundered different element > connected from the excel work-sheet into the word-report. This functioned > wery well. Each time I made a change in the excel- the change was to be seen > in the report in world. But I would like to test that all elements really > updates into the world-dokument so I can be sure that the report shall not > contain element which not are up to date. I am from Norwy, hope you can > understand what I try to explain and see more clearly now what is my whish. I > can allso add that the elements I have plased into the word-doc. have the > same format as the rest of the dok and is put into sentences. Therefore, you > will not be able to see that hhe coccected element is from an excel-work > sheet. > Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005) http://www.word.mvps.org This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-)

RE: How to control that objects I have imported from Excel really Kristian 12/24/2008 9:02:01 AM Hello again Cindy. I am so pleased with your answers to my questions. I have spent hours and days thinking and seeking solutions. Your guidance have been to a very good help for me. The funny thing is, what you tell me, is close to the same answers I myself have tendered to see as the solution. I have read all I can come over about the topic, without finding better answers than what you suggest to me. I am very grateful for your efforts to help, and must say you impresss me with your level of competance. I whish you a Merry Christmas and a Happy New Year from the land close to the North Pole. Kristian -- Kristian Cindy M. skrev: [Quoted Text] > Hi Kristian, > > I really can't think of any way to do what you ask, short of a macro that > compares the result with the original. But if one were to go to all that > trouble, then it would make just as much sense to use the macro to write the > data to the document (and would probably be twice as fast). > > Since Word 2007 tends to suppress error messages on links, there is simply no > way to determine whether a field has actually updated, short of comparing the > result to the link source. > > One possibility that occurs to me, that could be simpler than coding a > comparison, would be to include something, like that date, in the source. Build > the new report document, check for the date and, if it's there everywhere, > remove the date from the source then run the update again. > > > Thank you for your response. I am working in the office 2007. I have built a > > lot of statistics in excel. Elemenst from these statistics I shall use in a > > word-report ment to show how numbers have changed since the previous report > > made. I make one report for every three months, called quartal report. I made > > a test statsistics where I imported more than hundered different element > > connected from the excel work-sheet into the word-report. This functioned > > wery well. Each time I made a change in the excel- the change was to be seen > > in the report in world. But I would like to test that all elements really > > updates into the world-dokument so I can be sure that the report shall not > > contain element which not are up to date. I am from Norway, hope you can > > understand what I try to explain and see more clearly now what is my whish. I > > can also add that the elements I have placed into the word-doc. have the > > same format as the rest of the document and is put into sentences. Therefore, you > > will not be able to see that the connected element is from an excel-work > > sheet. > > > > Cindy Meister > INTER-Solutions, Switzerland > http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005) > http://www.word.mvps.org > > This reply is posted in the Newsgroup; please post any follow question or reply > in the newsgroup and not by e-mail :-) > >

RE: How to control that objects I have imported from Excel really Cindy M. <C.Meister-C[ at ]hispeed.ch> 12/25/2008 9:00:50 AM Hi Kristian, [Quoted Text] > what you tell me, is close to > the same answers I myself have tendered to see as the solution > I'm glad I was able to help you confirm which possibilities are available. All the best for the holiday season, from a few kilometers further south :-) Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005) http://www.word.mvps.org This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-)