Microsoft Word Error No Topic Specific
a Word document so that it automatically updates when the word document opens. Both are 2007 documents Copy / paste link is straightforward. However, as soon as I change the word settings to update links on open (either with a macro or via Tools / Options etc), the text "Error! No topic specified" replaces the link. I'd much appreciate guidance on how to correct this... PDJ, Jun 24, 2009 #1 Advertisements Cindy M. Guest Hi Pdj, > I'm trying to link an Excel file into a Word document so that it > automatically updates when the word document opens. Both are 2007 documents > > Copy / paste link is straightforward. However, as soon as I change the word > settings to update links on open (either with a macro or via Tools / Options > etc), the text "Error! No topic specified" replaces the link. > > I'd much appreciate guidance on how to correct this... Which version of Office, with what updates is this? (Look in Help/About) The only thing I find in the knowledge base (http://support.microsoft.com/default.aspx/kb/145641) is VERY old. But I suspect the basic information is still valid: something's not allowing the link to reach back to the application. You say the link is fine until you close and re-open the document. Are you sure? Have you tried explicitly forcing the update (click on the object and press F9)? I'm guessing the problem could be some security software, such as an anti-virus program. A lot of security software these days doesn't allow OLE "conversations" between applications. If you start Windows in Safe Mode do you see something different? 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 Cindy M., Jun 26, 2009 #2 Advertisements PDJ Guest Hi Cindy, Thanks for taking the time to respond. I tried forcing the update as suggested and switched off the anti-virus software but without success. For this particular exercise, I decided to re-write the code to copy the Excel range into the Word document rather than rely on a linked sheet. Again, thanks for the assistance. PDJ PDJ,
Thread Tools Display Modes #1 11-22-2014, 06:42 AM ptmuldoon Windows 7 64bit Office 2013 Advanced Beginner Join Date: Sep 2014 Posts: 90 Word Template with OLE Links Issues I am creating a template in Word 2007 that has a number of OLE links to various charts in excel. But I am always being prompted to Save the Template after a creating a new file from that template. This is with creating a NEW document based on the template. And not opening the template itself. I am also even prompted to save the template file even when saving just the docx file itself when that is the only file open. If I removed the OLE links, I can create a new document and then save without any http://www.office-forums.com/threads/error-no-topic-specified.1886089/ prompts to save the template, and things seem to work fine. The only info I found on the web is about including a macro in the template to save the template on close here. But I could not get that to work either. http://answers.microsoft.com/en-us/o...0-fc8a2c0d9015 If anyone has any suggestions. I open to trying anything. #2 11-22-2014, 08:30 AM ptmuldoon Windows 7 64bit Office 2013 Advanced Beginner Join Date: Sep 2014 Posts: 90 Doing as much reading as I can as well. http://www.msofficeforums.com/word/23648-word-template-ole-links-issues.html All I do is just open the template, and I see the Saved property in VBA changes to False. It may be better to move the topic over to the Word VBA area, as thay may be the only way to stop the prompts. But I've added the below macro in trying to troubleshoot, and still not working Code: Sub Test() 'Dim Doc As Document 'For Each Doc In Documents ' MsgBox Doc.AttachedTemplate.Name & vbTab & Doc.AttachedTemplate.Saved 'Next Dim Tmplt As Template For Each Tmplt In Templates MsgBox Tmplt.Name & vbTab & Tmplt.Saved Next End Sub Private Sub Document_Open() Dim Tmplt As Template For Each Tmplt In Templates ActiveDocument.AttachedTemplate.Saved = True Next ' MsgBox "Greetings" End Sub #3 11-22-2014, 03:05 PM ptmuldoon Windows 7 64bit Office 2013 Advanced Beginner Join Date: Sep 2014 Posts: 90 I'm still working on finding the cause, but from what I can tell Word is modifying the LINK code when Word first opens. I have done nothing then to simply open the Word Template file. And in testing, I see the link code is getting changed as follows The File opens as the follow link Code: { LINK Excel.Sheet.8 "C:\\Data\\Template\\Blank Workpapers.xlsm!Cover Charts!Charts_Cover_Main" "" \p } and then changes to the following Code: { LINK Excel.Sheet.8 "C:\\Data\\Template\\Blank Workpapers.xlsm" "Cover Charts!Charts_Cover_Main" \p } And I have done nothing other then simply open the Template file in word. You can see a couple of minor differences. The ! is removed by word, as well as tha
documents Copy / paste link is straightforward. However, as soon microsoft word as I change the word settings to update links on open (either with a macro or via Tools / Options etc), the text "Error! microsoft word error No topic specified" replaces the link. I'd much appreciate guidance on how to correct this... . Follow-Ups: Re: Error! No topic specified From: Cindy M . Prev by Date: Copy past problem Next by Date: Re: Ribbon adding control Previous by thread: Copy past problem Next by thread: Re: Error! No topic specified Index(es): Date Thread Flag as inappropriate (AWS) Windows Science Usenet ArchiveAboutPrivacyImprint www.tech-archive.net >Archive >Word >microsoft.public.word.vba.general >2009-06
εμάς.Μάθετε περισσότερα Το κατάλαβαΟ λογαριασμός μουΑναζήτησηΧάρτεςYouTubePlayΕιδήσειςGmailDriveΗμερολόγιοGoogle+ΜετάφρασηΦωτογραφίεςΠερισσότεραΈγγραφαBloggerΕπαφέςHangoutsΑκόμη περισσότερα από την GoogleΕίσοδοςΚρυφά πεδίαΒιβλίαbooks.google.gr - Everything a beginner needs to learn how to use Word is right here, presented in an easy-to-follow format. Absolute Beginner's Guide to Microsoft Office Word 2003 takes the reader through the basics, from starting Word to creating, editing, and formatting documents. The reader will learn how to use Word's...https://books.google.gr/books/about/Absolute_Beginner_s_Guide_to_Microsoft_O.html?hl=el&id=R1r1v----koC&utm_source=gb-gplus-shareAbsolute Beginner's Guide to Microsoft Office Word 2003Η βιβλιοθήκη μουΒοήθειαΣύνθετη Αναζήτηση ΒιβλίωνΑποκτήστε το εκτυπωμένο βιβλίοΔεν υπάρχουν διαθέσιμα eBookQue PublishingΕλευθερουδάκηςΠαπασωτηρίουΕύρεση σε κάποια βιβλιοθήκηΌλοι οι πωλητές»Αγορά βιβλίων στο Google PlayΠεριηγηθείτε στο μεγαλύτερο ηλεκτρονικό βιβλιοπωλείο του κόσμου και ξεκινήστε να διαβάζετε σήμερα στον ιστό, το tablet, το τηλέφωνο ή το ereader σας.Άμεση μετάβαση στο Google Play »Absolute Beginner's Guide to Microsoft Office Word 2003Laura AcklenQue Publishing, 2004 - 383 σελίδες 0 Κριτικέςhttps://books.google.gr/books/about/Absolute_Beginner_s_Guide_to_Microsoft_O.html?hl=el&id=R1r1v----koCEverything a beginner needs to learn how to use Word is right here, presented in an easy-to-follow format. Absolute Beginner's Guide to Microsoft Office Word 2003 takes the reader through the basics, from starting Word to creating, editing, and formatting documents. The reader will learn how to use Word's productivity tools, with lots of numbered steps to lead them through the process. Everything from styles to tables to clip art to charts is covered so when finished, the reader will feel confident about using Word's most powerful features. Προεπισκόπηση αυτού του βιβλίου » Τι λένε ο