#1
|
|||
|
|||
More OLE Link Issues
I'm going crazy over this Stuff !!
Ok. I have a macro that typically replaces the FilePath and FileName of each OLE Excel table and chart in my word file. Now, I fear I've uncovered an annoying bug when saving in the new .docx file format vs the older .doc file format. And hoping someone can confirm and possibly offer a solution. In testing. I have a Word 2013 file saved as a .docx file with 2 links. One is linked to and using a Named Range, and the other is linked to cell range. When you first copy that to Word, the Link Field code look as follows: Code:
{LINK Excel.SheetMacroEnabled.12 "C:\\Data\\Sample\\Sample.xlsm" "Cover Charts!Charts_Cover_Main" \a \p} {LINK Excel.SheetMacroEnabled.12 "C:\\Data\\Sample\\Sample.xlsm" "Cover Charts!R28C10:R34C14" \a \p Code:
{LINK Excel.SheetMacroEnabled.12 "C:\\Data\\Sample\\Sample.xlsm!Cover Charts!Charts_Cover_Main" "" \a \p} {LINK Excel.SheetMacroEnabled.12 "C:\\Data\\Sample\\Sample.xlsm!Cover Charts!R28C10:R34C14" "" \a \p} The Problem.... When you first open the Word document, that modification of the Word file 'breaks' the ability to read the file name. when I open the word document, and run the following; Code:
Sub SourceFileName() Dim s As Variant For Each s In ActiveDocument.InlineShapes MsgBox s.LinkFormat.SourceName Next s End Sub For the NamedRange, it gives the filename plus the named range of Code:
Sample.xlsm!Cover Charts!Charts_Cover_Main Code:
R34C14 Thanks PT |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
OneNote Online "Sorry, OneNote Online can't open this link" (Link to a Page within a Section Group) | ross5 | OneNote | 2 | 02-09-2015 06:16 PM |
Trying to link page numbers in the footer, but refuses to link after new section | fl0shizzle | Word | 7 | 05-06-2014 12:15 PM |
How to link an object to a URL link to update automatically | expert4knowledge | Excel | 1 | 06-11-2012 09:30 AM |
Excel to Powerpoint Link issues | Weather | PowerPoint | 0 | 02-01-2011 02:02 PM |
Issues with synchronization log causing send/receive issues | WinSock64 | Outlook | 0 | 01-11-2011 11:29 AM |