Error No Topic Specified Excel
SolutionsMembership ComparisonOur Application FormsRegisterSearch "Excel VBA Help" Play Friv Now - Play Friv Games The Code Cage Forums > Microsoft Topics > Microsoft Word Forum Error! No topic specified Our Info Pages:- Latest Excel Posts Latest Access Posts Latest Powerpoint Posts Latest Project Posts Publisher Posts Latest Visio Posts Latest Outlook Posts Latest Word Posts Lisa's VBA Clean Up Financial Modelling File System Object Writing to text files Using Regular Expressions Tutorial Directory Project Directory List of all pages User Name Remember Me? Password Notices You Have 1 New Private Message Waiting! Unregistered, You might find Lisa's Greens fantastic VBA CleanUp and Variable Insertion Tool invaluable when creating any VBA Procedure!You can find the live project Here!Join in the discussion in the thread for more information or help. Unregistered, If you have ever had issues with Excel's startup then look here Jan Karel Pieterse's Excel StartUp Problems Resolved!This page is an exact reproduction by kind permission of Jan Karel Pieterse The content was too good to leave missing from our forums! Donate at least £2 and you'll become a forum VIP for 6 months!,you wont see any ads and the forum will load faster This will only be available for the next 4 weeks! Thanks for making this a great forum, free and always online, your help is appreciated you'll become a forum VIP! Microsoft Word Forum Members, post questions in this forum if they are related to using Microsoft Word, this includes Document Properties, VBA Programming & Functionality etc. Search Forums Show Threads Show Posts Tag Search Advanced Search Search Links/Downloads Description Keys Advanced Search Find All Thanked Posts Go to Page... New Reply View First Unread Thread Tools Rate Thread Display Modes #1 24th June 2009, 15:35 PDJ Newsgroup Contributor Posts: n/a Posts Per Day: 0 My Top Tip Count: Error! No topic specified Word: VBA ------ Register to get rid of these "In Post" ads! ------ Category: Word: VBA 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 upd
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 http://www.thecodecage.com/forumz/showthread.php?t=109682 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 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 http://www.msofficeforums.com/word/23648-word-template-ole-links-issues.html 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. 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 2
Forum Microsoft Office Application Help - Excel Help forum Excel General Error! No topic specified. when linking an excel range of cells into a Word document To get replies by http://www.excelforum.com/showthread.php?t=862345 our experts at nominal charges, follow this link to buy points and post your thread in our Commercial Services forum! Here is the FAQ for this forum. + Reply to Thread Results 1 to 1 of 1 Error! No topic specified. when linking an excel range of cells into a Word document Thread Tools Show Printable Version Subscribe to this Thread… Rate error no This Thread Current Rating Excellent Good Average Bad Terrible Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 09-21-2012,12:34 PM #1 Aileens_UK View Profile View Forum Posts Registered User Join Date 09-21-2012 Location Miami, Florida MS-Off Ver Excel 2010 Posts 1 Error! No topic specified. when linking an excel range of cells into a Word document error no topic Hi, I'm trying to link from a Word doc, a range of cells in Excel. I get the error msg: Error! No topic specified. I have no idea what this means. This is what I have inside the field brackets {}: LINK Excel.Sheet.8 " C:\\Users\\Administrator\\Documents\\_ Format it\\Dave \\cenvilupdated.xls" HW!R12C2:R21C8 \a \p Any idea what could be wrong? Thanks for your help. ~Eileen Register To Reply + Reply to Thread « Previous Thread | Next Thread » Thread Information Users Browsing this Thread There are currently 1 users browsing this thread. (0 members and 1 guests) Tags for this Thread linking excel to View Tag Cloud Bookmarks Bookmarks Digg del.icio.us StumbleUpon Google Posting Permissions You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is Off HTML code is Off Forum Rules -- vB4 Default Style -- Mobile Style Premium -- Lightweight Contact Us ExcelTip.com Archive Top All times are GMT -4. The time now is 01:40 AM. Powered by vBulletin® Version 4.1.8 Copyright ©