Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-18-2021, 11:48 PM
ggll ggll is offline @Macropod Macro VBA LINK Fields Relative Paste Special as Image from Excel word bug Windows 10 @Macropod Macro VBA LINK Fields Relative Paste Special as Image from Excel word bug Office 2016
Novice
@Macropod Macro VBA LINK Fields Relative Paste Special as Image from Excel word bug
 
Join Date: Sep 2021
Posts: 1
ggll is on a distinguished road
Default @Macropod Macro VBA LINK Fields Relative Paste Special as Image from Excel word bug

Hello, I am new to this forum and face a serious problem that has been / seems to be there for ages. (Version of Office : 2016 pro Edition)




I have a master word document (a reporting that will change at each period) in which I have paste special as images * part of one consolidated Excel document. Both will be duplicated and will be updated (changing names and place indeed, etc)

They work well initially but changing location (or name) is a problem (always the same problem for links ~/ ...) but I found in the end the wonderful macro of Paul aka Macropod and its explanations (regarding the nasty habit of Links and linked images).
I added the macro but it still doesnt work (I dont know how to specify in the debug the new path for instance, updating to be manual too is impossible even if the macro monitors it,...), changing manually the links in the ALT+F9 do not work (OLE issues I guess), I am surely making something wrong but does someone know if it is possible in the end (and the process to follow).
It's not a big deal to change or update its links to the new path one by one at each change of location and name (not the elements part however) (office propose a solution but it seems bugged), however otherwise a mere copy paste as image do the job (prehistoric solution) and will need to be redone over and over.

I thought lots of progress were made and that recently office documents better communicate (does a 365 edition be better ? the company is for security at 2016)

Any help or good advice would be appreciated, I am lost and see coming the cynical and nasty comments at work ('you know you can use the shortcut CTRL+C and CTRL+V it works you know')



* Why as image (to keep the format) but maybe its not the best option too so far.
Reply With Quote
Reply

Tags
paste special, relative path

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
@Macropod Macro VBA LINK Fields Relative Paste Special as Image from Excel word bug Word relative link to excel - How can you explain this ? SamVDS Word 6 04-10-2020 01:41 AM
@Macropod Macro VBA LINK Fields Relative Paste Special as Image from Excel word bug Relative link (same folder) from Excel cell into Word file SparFuX Word 1 12-18-2018 03:22 PM
Word Paste Special greys out sporadically when copying tables from Excel rtb Word 0 07-08-2018 09:45 AM
need a shortcut for paste special link unformatted text noetic76 Word VBA 2 06-29-2014 06:40 PM
Paste Special Link no longer working MrsMoe PowerPoint 0 12-20-2010 10:54 PM

Other Forums: Access Forums

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