Excel2007, hyperlink in CSV schreiben

		Microsoft Office Forums > Microsoft Excel > Excel
Excel2007, hyperlink in CSV schreiben

04-28-2017, 06:54 AM

dherr

Windows 8

Office 2007

Advanced Beginner

Join Date: Nov 2014

Location: Austria

Posts: 45

Hi,,
also zumindest das Herausfinden der Link-Adresse lässt sich mit folgendem kleinen Makro machen:

Code:

Sub Makro1()
    Range("A1").Select
    adr = Selection.Hyperlinks(1).Address
    Range("A1").Select
    Selection.Value = adr
End Sub

Nun müsste man diesen Link auch als Text in CSV schreiben können.

Grüße-
Dietrich

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Change in MySQL or Excel2007 making interaction unreliable	Billirl	Other Software	0	02-07-2016 06:40 AM
Moving from hyperlink to hyperlink in a document	Bengt	Word VBA	2	12-21-2015 12:42 AM
Hyperlink: open the document only once, quit & reopen PP, hyperlink doesnt work anymore	quanghuynguyenhua	PowerPoint	0	10-10-2015 06:17 PM
Hyperlink Format varies, depending on whether Target file was saved or unsaved on Hyperlink Copy	RichardDavey	Word	0	05-26-2015 05:26 PM
Insert the Hyperlink and hide all sheets except clicking Hyperlink	PRADEEPB270	Excel	1	02-22-2013 09:47 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:37 PM.