P
Paul
I have a large number of worksheets where the urls have been entered as
hyperlinks. I need to export the entire contents of these sheets as flat
files to be used elsewhere. Right now my problem is that I can find no
way of exporting the underlying url.
When I try and export as .csv for instance I get for the columns of
interest "MyURL" showing as plain text rather the the target I need of
"http://MyUrl.com".
Does anyone know of a way I can either export in such a manner as to
reveal the url during the export or edit the sheets using a macro or
whatever so as to reveal the underlying urls. There are way to many of
these things to try and do by hand. Thanks if advance.
BTW Beer is on me for the first person who can help me out of this jamb!!!
Paul
hyperlinks. I need to export the entire contents of these sheets as flat
files to be used elsewhere. Right now my problem is that I can find no
way of exporting the underlying url.
When I try and export as .csv for instance I get for the columns of
interest "MyURL" showing as plain text rather the the target I need of
"http://MyUrl.com".
Does anyone know of a way I can either export in such a manner as to
reveal the url during the export or edit the sheets using a macro or
whatever so as to reveal the underlying urls. There are way to many of
these things to try and do by hand. Thanks if advance.
BTW Beer is on me for the first person who can help me out of this jamb!!!
Paul