#1
|
|||
|
|||
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. |
#2
|
||||
|
||||
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 |
#3
|
|||
|
|||
> 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. |
#4
|
|||
|
|||
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 !!
|
#5
|
|||
|
|||
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 ? |
#6
|
||||
|
||||
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 |
#7
|
|||
|
|||
Thx - I'll study the links you gave !
|
#8
|
|||
|
|||
Quote:
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 ! |
#9
|
||||
|
||||
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 |
#10
|
|||
|
|||
Quote:
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. |
#11
|
|||
|
|||
Do you run into the same errors ... or ?
SOS, HELP, HELP , MAYDAY, MAYDAY ! |
#12
|
||||
|
||||
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 |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Help solve this problem. | Belise Leavitt | Project | 1 | 02-16-2018 04:32 PM |
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 |
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 |