Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-09-2023, 01:47 PM
macropod's Avatar
macropod macropod is offline Need a macro that can shift an image and format it Windows 10 Need a macro that can shift an image and format it Office 2016
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

I believe you'll find the white space around the QR code is part of the QR code specification. That may be a fixed amount of white space or a white space proportional to the size of the QR code itself. Its reduction or removal (including by repositioning within the label) is liable to compromise the integrity of any QR code scanning. Placing the code behind the text will cause the text to intrude on that white space and potentially to obscure parts of the QR code itself.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #2  
Old 01-09-2023, 01:57 PM
sessilelessile sessilelessile is offline Need a macro that can shift an image and format it Windows 10 Need a macro that can shift an image and format it Office 2016
Novice
Need a macro that can shift an image and format it
 
Join Date: Jan 2023
Posts: 3
sessilelessile is on a distinguished road
Default

Thank you for the lesson on how QR codes work!

Thankfully the way the label template is set up there will always be room for the QR to have 'white space' around it (it gets printed on black metal so it's inverted), however the border is unnecessarily large.

With the QR code being manually manipulated to be "behind text" (picture formatting not literally behind text) and shifted to the left, it still functions. I just need a macro to repeat this process.

Best.
Reply With Quote
  #3  
Old 01-09-2023, 02:06 PM
macropod's Avatar
macropod macropod is offline Need a macro that can shift an image and format it Windows 10 Need a macro that can shift an image and format it Office 2016
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 sessilelessile View Post
Thankfully the way the label template is set up there will always be room for the QR to have 'white space' around it (it gets printed on black metal so it's inverted), however the border is unnecessarily large.
In that case, simply changing the table cell border size may be all you need. That should be done once - in the mailmerge main document - before the merge is executed.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Tags
image, macro, picutre



Similar Threads
Thread Thread Starter Forum Replies Last Post
Need a macro that can shift an image and format it How can I create a macro to shift the content of all subsequent footnotes up one position? Atfon Word VBA 4 03-29-2016 05:51 AM
Need a macro that can shift an image and format it Shift Excel Cell after executing a macro for second time LearningMacro Excel Programming 2 01-08-2015 03:05 PM
Need a macro that can shift an image and format it 1.image in a table 2.right click 3.menu click format 4.a format column appears OldFatDog Drawing and Graphics 1 06-13-2014 11:19 PM
Need a macro that can shift an image and format it Noob here - I need a shift calendar by days with count of shift. freeman Excel 8 09-12-2012 08:45 AM
Need a macro that can shift an image and format it Vector image format jespestana Drawing and Graphics 4 11-26-2010 03:51 AM

Other Forums: Access Forums

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