Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-16-2020, 11:36 AM
neilwhite neilwhite is offline Batch Hyperlinking files Windows 10 Batch Hyperlinking files Office 2016
Novice
Batch Hyperlinking files
 
Join Date: Jan 2020
Posts: 6
neilwhite is on a distinguished road
Default

Thanks so much for this, it’s massively appreciated. I have had a quick play and it looks pretty much spot on. One issue is that each header shows the full pile path not just that header.
I’ll have a proper sit down with it over the weekend!

Thanks again!
Reply With Quote
  #2  
Old 04-16-2020, 02:30 PM
macropod's Avatar
macropod macropod is offline Batch Hyperlinking files Windows 7 64bit Batch Hyperlinking files Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by neilwhite View Post
Thanks so much for this, it’s massively appreciated. I have had a quick play and it looks pretty much spot on. One issue is that each header shows the full pile path not just that header.
That was intentional - it wasn't apparent from your specs as to how much was to be retained. To get just the file's own folder, change:
.InsertAfter vbCr & strRelPath & vbCr
to:
.InsertAfter vbCr & Split(strRelPath, "")(h - 2) & vbCr
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 04-20-2020, 03:04 AM
neilwhite neilwhite is offline Batch Hyperlinking files Windows 10 Batch Hyperlinking files Office 2016
Novice
Batch Hyperlinking files
 
Join Date: Jan 2020
Posts: 6
neilwhite is on a distinguished road
Default

Thanks again Paul. What you have provided is great and is so close to what I need to achieve. I appreciate that your not here just to provide the script for me and I'm trying to learn VBA but it's quite a learning curve to achieve this. I will try and resolve this myself but if your generosity extends to look at this I've added a onedrive link below to a dummy folder structure. This includes a word doc which includes the heading structure etc I need to end up with, It might make more sense than how I have described it!

Microsoft services

Like I said if you cannot assist, I completely understand.

Thanks again.

Last edited by neilwhite; 04-20-2020 at 03:29 AM. Reason: I cant spell!
Reply With Quote
Reply

Tags
batch processing, hyperlinking

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Batch Comparing Multiple Word Files scienceguy Word VBA 2 10-27-2021 07:43 AM
Batch Hyperlinking files Batch add suffix to PDF files in folder Dave T Windows 2 03-01-2016 08:07 PM
Remove Compatibility Mode on DOCX files (batch) w64bit Word 17 02-01-2015 06:02 AM
Batch Hyperlinking files how to batch update linked image files path? stanleyhuang Word 3 09-11-2014 12:51 AM
Hyperlinking files on a mapped network drive howler2345 Outlook 0 12-21-2011 08:54 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:34 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