Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 01-21-2023, 08:09 PM
AlanCantor AlanCantor is offline Remove hypertext from clipboard Windows 10 Remove hypertext from clipboard Office 2019
Competent Performer
Remove hypertext from clipboard
 
Join Date: Nov 2020
Posts: 154
AlanCantor is on a distinguished road
Default Remove hypertext from clipboard

I'm using a script that copies the content of a table in a Word document:



Code:
Selection.Tables(1).Range.Copy
The script has been working beautifully... until I stumbled on a problem: a subsequent step in the macro fails if a cell in the table contains hypertext (e.g., a clickable email or web address).

This problem would evaporate if I could strip away the hypertext from the selection, or from the clipboard after the text is copied.

Any thoughts on how my macro might eliminate hypertext? Example: if xxx@yyy.zzz is a clickable link in the table, I want the text of the email address, but without it being a hypertext.

I'd be good if the macro stripped away hypertext from the table before copying the table. But my preference would be for the change to happen in Variable-Land.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Changing hypertext to normal text tcritchley07 Word 2 11-23-2019 09:52 AM
Error with Clipboard - Getting Spaces Out of Clipboard StephenRay Word VBA 14 09-27-2017 01:07 PM
Remove hypertext from clipboard Hypertext links within document? (not to a website) cosiyak Word 1 05-22-2011 01:26 PM
Remove hypertext from clipboard Hypertext Question Juc1 Word 6 05-05-2011 06:09 AM
Remove hypertext from clipboard hypertext link to a specific page of a pdf file serbring OneNote 6 03-04-2011 01:20 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:56 PM.


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