Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 03-30-2014, 01:36 PM
ctreharne ctreharne is offline Word 2003 OLE links Windows 7 64bit Word 2003 OLE links Office 2003
Novice
Word 2003 OLE links
 
Join Date: Mar 2014
Posts: 1
ctreharne is on a distinguished road
Default Word 2003 OLE links

I'm trying to migrate elaborate Word and Excel templates from Office 2003 (yes, I'm a dinosaur) to Office 2013.

We can have as many as 125 internal links within Word (i.e., from Word text to Word text) and another 125 external links (i.e., from Excel to Word). The external links can be as simple as one number being imported to the narrative and as complex as 12 columns by 25 row Excel array in an exhibit.

Here's an example of a Word 2003 internal link:
{ LINK Word.Document.8 "\\\\server name\\drive name\\client folder\\project name130401.doc" OLE_LINK97 \r \* MERGEFORMAT }

Here's an example of a Word 2003 from Excel 2003 external link:
{ LINK Excel.Sheet.8 "\\\\server name\\drive name\\client folder\\project name130401.xls" BS!R102C1:R120C11 \f 4 \r \* MERGEFORMAT }

(as i more closely review the Excel to Word link, I notice that it doesn't say OLE_LINK like the internal Word link says; so maybe it's a technology other than OLE linking)

I've been told by more than one alleged expert that I should no longer rely on OLE llinking technology for security reasons (which I don't understand, partiuclarly since our OLE links never go out of house; our reports always go out in PDF format).

I tried using linking Excel 2013 arrays to Word 2013, but the imported Excel arrays don't retain their formatting (even though I've told them to). More specifically, the entry in the last row in the Excel array overflows to the next line (to be clear, it never did in Word 2003, or if it did, we could fix it) and reverts to its original font style and size.

I've seen linking similar to OLE links in a more current version (unknown) of Office, but my competitor wouldn't share the technology with me - go figure.

How can I update the embeeded Office 2003 OLE linking technology (both Word internal OLE links and external Excel-to-Word links) in to new Office 2013 templates without having to do a massive redesign of my Office 2003 templates?
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Links need to be Hot links in Bibliography in Word 2010, 2013 synses Word 1 11-23-2013 12:48 AM
Breaking Links In A Formula And Making Them Values, Office 2003 tcohen Excel 1 03-18-2013 07:05 AM
Word 2003 OLE links Links in MS Word greendean Word 6 03-12-2013 02:36 PM
MS 2003 cross reference links break down mkj256 Word 0 08-24-2010 08:46 AM
Cannot click HTTP links in Office 2003 w/ IE8 CntdwnToExtn Office 0 06-24-2010 09:07 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:24 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft