Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-18-2014, 07:03 AM
Faire Faire is offline OLE refering to current document Windows 7 32bit OLE refering to current document Office 2010 32bit
Novice
OLE refering to current document
 
Join Date: Aug 2014
Posts: 5
Faire is on a distinguished road
Question OLE refering to current document


Hello, I am using a Word form to fill in information collected on the first page into following pages. I have used the OLE objects to do that (copy form component, insert as a link), however the OLE links refer to the original document while I would like it to refer to the currently opened document (which would allow me to use several forms at once). Is it possible to do that? I know there are more ways to skin the cat (scripting, XML component) but cope-special paste is probably the only option I have now.
Reply With Quote
  #2  
Old 08-19-2014, 03:14 AM
Stefan Blom's Avatar
Stefan Blom Stefan Blom is offline OLE refering to current document Windows 7 64bit OLE refering to current document Office 2013
Moderator
 
Join Date: Aug 2011
Posts: 3,907
Stefan Blom is a name known to allStefan Blom is a name known to allStefan Blom is a name known to allStefan Blom is a name known to allStefan Blom is a name known to allStefan Blom is a name known to all
Default

Fields or content controls are usually easier if you want to reuse information. See http://gregmaxey.com/word_tip_pages/repeating_data.html.
__________________
Stefan Blom
Microsoft Word MVP

Microsoft 365 apps for business
Windows 11 Professional
Reply With Quote
  #3  
Old 08-19-2014, 08:43 AM
Faire Faire is offline OLE refering to current document Windows 7 32bit OLE refering to current document Office 2010 32bit
Novice
OLE refering to current document
 
Join Date: Aug 2014
Posts: 5
Faire is on a distinguished road
Default

Hello, I am using content control text fields (I hope that is the propper term, I am using a different language variation). My issue is that OLE links are absolute - linking to the original document, while I need them to link to the actual document.
Reply With Quote
  #4  
Old 08-19-2014, 10:07 AM
Stefan Blom's Avatar
Stefan Blom Stefan Blom is offline OLE refering to current document Windows 7 64bit OLE refering to current document Office 2013
Moderator
 
Join Date: Aug 2011
Posts: 3,907
Stefan Blom is a name known to allStefan Blom is a name known to allStefan Blom is a name known to allStefan Blom is a name known to allStefan Blom is a name known to allStefan Blom is a name known to all
Default

Sorry, I don't understand why you need OLE links. Could you elaborate on that?
__________________
Stefan Blom
Microsoft Word MVP

Microsoft 365 apps for business
Windows 11 Professional
Reply With Quote
  #5  
Old 08-19-2014, 10:27 AM
Faire Faire is offline OLE refering to current document Windows 7 32bit OLE refering to current document Office 2010 32bit
Novice
OLE refering to current document
 
Join Date: Aug 2014
Posts: 5
Faire is on a distinguished road
Default

Sure! The first page is used to collect the data (identification of subjects, dates...). Rest of the pages are documents that are using these data. So I put the name in a text area in the first page and it is automatically filled-in on the rest of the pages. Each data is used multiple times.

I am sorry for my English
Reply With Quote
  #6  
Old 08-19-2014, 11:52 AM
Stefan Blom's Avatar
Stefan Blom Stefan Blom is offline OLE refering to current document Windows 7 64bit OLE refering to current document Office 2013
Moderator
 
Join Date: Aug 2011
Posts: 3,907
Stefan Blom is a name known to allStefan Blom is a name known to allStefan Blom is a name known to allStefan Blom is a name known to allStefan Blom is a name known to allStefan Blom is a name known to all
Default

How are you creating these OLE links? I tested using Paste Special and noticed no difficulties with content from within the file.

However, as I already said, I think you will find http://gregmaxey.com/word_tip_pages/repeating_data.html more useful...
__________________
Stefan Blom
Microsoft Word MVP

Microsoft 365 apps for business
Windows 11 Professional
Reply With Quote
  #7  
Old 08-20-2014, 01:07 AM
Faire Faire is offline OLE refering to current document Windows 7 32bit OLE refering to current document Office 2010 32bit
Novice
OLE refering to current document
 
Join Date: Aug 2014
Posts: 5
Faire is on a distinguished road
Default

That was one of the first webpages I have checked I wish I could just paste a screenshot, but it's all in Czech. So, the automatic filling works just fine. My problem is that the source for each OLE is absolute - linked to the original document. I am using the original document as a template - I fill it in and then save it as a different file. However all the OLE links in the new document are still pointing to the original document - which means they will not update based on changes in the new document, but only when the original document is changed.

I would need the OLE links to be relative - always pointing to the document that is being used right now (that is the new one, not the original one) - then I will be able to update form fields (content controls) at wish in every new copy I will create.

Is it a bit clearer?
Reply With Quote
  #8  
Old 08-25-2014, 11:28 AM
Stefan Blom's Avatar
Stefan Blom Stefan Blom is offline OLE refering to current document Windows 7 64bit OLE refering to current document Office 2013
Moderator
 
Join Date: Aug 2011
Posts: 3,907
Stefan Blom is a name known to allStefan Blom is a name known to allStefan Blom is a name known to allStefan Blom is a name known to allStefan Blom is a name known to allStefan Blom is a name known to all
Default

OK, I see what you mean, but I'm afraid I don't have a useful suggestion... :-(
__________________
Stefan Blom
Microsoft Word MVP

Microsoft 365 apps for business
Windows 11 Professional
Reply With Quote
  #9  
Old 08-25-2014, 09:46 PM
Faire Faire is offline OLE refering to current document Windows 7 32bit OLE refering to current document Office 2010 32bit
Novice
OLE refering to current document
 
Join Date: Aug 2014
Posts: 5
Faire is on a distinguished road
Default

That's ok, thanks for you time and energy!
Reply With Quote
Reply

Tags
ole, relative path



Similar Threads
Thread Thread Starter Forum Replies Last Post
OLE refering to current document refering to the msoFileDialogueOpen variants smndnm Word VBA 23 07-20-2014 04:55 PM
Refering figure number too text danzi Word 1 01-20-2012 12:13 PM
OLE refering to current document How to call current PC date and/or current PC year KIM SOLIS Excel 2 11-04-2011 06:09 PM
Refering to photos on other pages woodfind Word 1 05-17-2010 01:52 AM
OLE refering to current document Auto insert current month's name and current year Styler001 Word 4 01-25-2010 06:40 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:55 AM.


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