Creo Tutorials

Creo Tutorials

About the blog:

New Creo Parametric tutorials to showcase the new features, functions, configuration, renderings and animation with best practice, tips and tricks. You can find more on YouTube.com

Excel tutorial: How to Copy Hyperlink To Clipboard

Tips and TricksPosted by Ing. Vladimir Palffy Tue, December 05, 2017 10:01AM

Hi folks - In this video tutorial I will show you How to setup Excel script for: Copy Excel Hyperlink to Clipboard

---------------------------------------------------------------

Used script:

Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)

Application.GoTo Reference:=Target.Range

Call CopyHyperlinkToClipboard(Target)

End Sub

Sub CopyHyperlinkToClipboard(Target)

Dim MyData As New DataObject

Row = Target.Range.Row

Column = Target.Range.Column

Chtoc = Cells(Row, Column).Value

MyData.SetText Chtoc

MyData.PutInClipboard

End Sub

---------------------------------------------------------------

---------------------------------------------------------------

Add New Reference (more info in the video):

Tools-References: c:\Windows\SysWOW64\FM20.DLL

---------------------------------------------------------------



  • Comments(0)