Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-17-2019, 08:28 AM
ksor ksor is offline Ideas to solve a folder problem problem ?? Windows 10 Ideas to solve a folder problem problem ?? Office 2016
Advanced Beginner
Ideas to solve a folder problem problem ??
 
Join Date: Feb 2018
Location: Århus V, Denmark
Posts: 74
ksor is on a distinguished road
Default Ideas to solve a folder problem problem ??

I have some WORD-documents in some subfolders but all in a main folder.

A lot of these documents have links to local videos files inserted.

It works really nice but a fool just moved the main folder !

Can you imagine what happened - the links doesn't work any more !

The reason I want the video files themself to NOT be a part of the document is that it will dramaticly increase the time to open/close the documents !

How can I include a predefined path to the main folder into the path of these links without the user have to do VBA programming ... OR do you have a better idea ?


Last edited by ksor; 10-17-2019 at 02:22 PM.
Reply With Quote
  #2  
Old 10-17-2019, 09:39 PM
Guessed's Avatar
Guessed Guessed is offline Ideas to solve a folder problem problem ?? Windows 10 Ideas to solve a folder problem problem ?? Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,932
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

Are these links hyperlinks? If so, you can toggle your field codes (Shift-F9) so you can see the full paths as a field and then do a search and replace to update the path. Then toggle the field codes back again by pressing Shift-F9
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #3  
Old 10-17-2019, 10:37 PM
ksor ksor is offline Ideas to solve a folder problem problem ?? Windows 10 Ideas to solve a folder problem problem ?? Office 2016
Advanced Beginner
Ideas to solve a folder problem problem ??
 
Join Date: Feb 2018
Location: Århus V, Denmark
Posts: 74
ksor is on a distinguished road
Default

> Guessed
SOme of the links are links to somewhere on the internet and some are to local files in sub folders in the main folder.

Yeah, you can see the FULL path IF it's pointing to somewhere on the internet but NOT the full path if it's pointing to a local file AND it's a little tricky for the user to do, I think.

I wonder if a macro could be made to do the job but here the problem is, that only ACCESS knows the path to the main folder ... and can I get this path from some VBA code in WORD ... and then again, the user should REMEMBER to do it, but only with links to local files ... it IS indeed a little tricky.
Reply With Quote
  #4  
Old 10-20-2019, 06:11 AM
ksor ksor is offline Ideas to solve a folder problem problem ?? Windows 10 Ideas to solve a folder problem problem ?? Office 2016
Advanced Beginner
Ideas to solve a folder problem problem ??
 
Join Date: Feb 2018
Location: Århus V, Denmark
Posts: 74
ksor is on a distinguished road
Default

EDIT: Another thing is that opening/closing of the files are very, very slow and the user get asked if he want to save ... when just seen the video - it's confusing !!
Reply With Quote
  #5  
Old 10-20-2019, 06:18 AM
ksor ksor is offline Ideas to solve a folder problem problem ?? Windows 10 Ideas to solve a folder problem problem ?? Office 2016
Advanced Beginner
Ideas to solve a folder problem problem ??
 
Join Date: Feb 2018
Location: Århus V, Denmark
Posts: 74
ksor is on a distinguished road
Default

I found that the "slow opening/closing/asking to save"-problem can be solved by inserting the video as Object with a chain to the file !


Still I have a problem IF the mainfolder with the video files in a subfolder is moved, BUT ...


I can't find out to see the path&filename to the chained file


Can the PATH to the chained file be manipulated by VBA ?
Reply With Quote
  #6  
Old 10-20-2019, 06:48 PM
Guessed's Avatar
Guessed Guessed is offline Ideas to solve a folder problem problem ?? Windows 10 Ideas to solve a folder problem problem ?? Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,932
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

I'm not sure how your videos are linked into the doc but the code on this page LinkFormat.SourceFullName property (Word) | Microsoft Docs might get you started.

If your linked objects are inline shapes you would have to change .Shapes to .InlineShapes

See also microsoft excel - Updating link paths with Word VBA - Super User for more info.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #7  
Old 10-21-2019, 12:39 AM
ksor ksor is offline Ideas to solve a folder problem problem ?? Windows 10 Ideas to solve a folder problem problem ?? Office 2016
Advanced Beginner
Ideas to solve a folder problem problem ??
 
Join Date: Feb 2018
Location: Århus V, Denmark
Posts: 74
ksor is on a distinguished road
Default

Thx - I'll study the links you gave !
Reply With Quote
  #8  
Old 10-21-2019, 11:34 AM
ksor ksor is offline Ideas to solve a folder problem problem ?? Windows 10 Ideas to solve a folder problem problem ?? Office 2016
Advanced Beginner
Ideas to solve a folder problem problem ??
 
Join Date: Feb 2018
Location: Århus V, Denmark
Posts: 74
ksor is on a distinguished road
Default

Quote:
Originally Posted by Guessed View Post
I'm not sure how your videos are linked into the doc but the code on this page LinkFormat.SourceFullName property (Word) | Microsoft Docs might get you started.

If your linked objects are inline shapes you would have to change .Shapes to .InlineShapes

See also microsoft excel - Updating link paths with Word VBA - Super User for more info.

It seems like the first link is just what I need, but I wonder why I can't get it to work !


I created a word-document with ONE inserted object as a chained file (a mp4.video)


I open the document and then open the immediate window to investigate:


? ActiveDocument.InlineShapes.Count
1

? ActiveDocument.InlineShapes.Item(1).Type=wdInlineS hapeEmbeddedOLEObject
True



then I try this:
? ActiveDocument.InlineShapes.Item(1).LinkFormat.Sou rceFullName



but it give me errormessage. Runtime error 91 - Object variable not set


How can I get this under my skin - help me !
Reply With Quote
  #9  
Old 10-21-2019, 02:34 PM
Guessed's Avatar
Guessed Guessed is offline Ideas to solve a folder problem problem ?? Windows 10 Ideas to solve a folder problem problem ?? Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,932
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

Post a sample document that shows how you are linking to the videos. There are different ways to do this and we can't suggest the right way to manage this without knowing what your document link you have.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #10  
Old 10-21-2019, 11:03 PM
ksor ksor is offline Ideas to solve a folder problem problem ?? Windows 10 Ideas to solve a folder problem problem ?? Office 2016
Advanced Beginner
Ideas to solve a folder problem problem ??
 
Join Date: Feb 2018
Location: Århus V, Denmark
Posts: 74
ksor is on a distinguished road
Default

Quote:
Originally Posted by Guessed View Post
Post a sample document that shows how you are linking to the videos. There are different ways to do this and we can't suggest the right way to manage this without knowing what your document link you have.

Argh, ... this way:


Create a new empty document,

click INSERT/OBJECT
choose TAB "Create from file"

check both checkboxes
choose your video file
click OK


(My translations because I have WORD in a danish version !)


that's it !


Then save the document and go to the immidiate window and do the typing I showed in my earlier posting - no need to repeat here ... I think.
Reply With Quote
  #11  
Old 10-23-2019, 11:31 PM
ksor ksor is offline Ideas to solve a folder problem problem ?? Windows 10 Ideas to solve a folder problem problem ?? Office 2016
Advanced Beginner
Ideas to solve a folder problem problem ??
 
Join Date: Feb 2018
Location: Århus V, Denmark
Posts: 74
ksor is on a distinguished road
Default

Do you run into the same errors ... or ?


SOS, HELP, HELP , MAYDAY, MAYDAY !
Reply With Quote
  #12  
Old 10-24-2019, 03:03 AM
Guessed's Avatar
Guessed Guessed is offline Ideas to solve a folder problem problem ?? Windows 10 Ideas to solve a folder problem problem ?? Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,932
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

Yes, I'm running in to the same errors. Not sure if there is a way forward for that because I haven't had any success on a few things I've tried so far.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help solve this problem. Belise Leavitt Project 1 02-16-2018 04:32 PM
Ideas to solve a folder problem problem ?? How to Solve a Font Book Problem? Tango Mike Word 5 06-27-2016 07:24 AM
Can anyone solve this problem? ChrisHoppyBot Office 0 02-20-2013 01:08 AM
Ideas to solve a folder problem problem ?? Can anyone solve my problem? sid44 Word 1 05-16-2011 09:06 AM
A problem that is impossible to solve... A F 1 G 3 Word 0 09-17-2010 09:32 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:32 PM.


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