Url to hypertext

M

Me

Hi.

I used an Excel spreadsheet with active urls to create a merge file in
Publisher. The urls converted to text with the merge. Does anyone know how
to batch convert the text back to an active hyperlink, or if there is a
macro somewhere? The spreadsheet has hundreds of urls on it.

Thanks for any help.
 
R

Rob Giordano \(Crash Gordon®\)

I'm not sure. But, I'm curious as to why you would need active hypertext in a document that's intended for print?


| Hi.
|
| I used an Excel spreadsheet with active urls to create a merge file in
| Publisher. The urls converted to text with the merge. Does anyone know how
| to batch convert the text back to an active hyperlink, or if there is a
| macro somewhere? The spreadsheet has hundreds of urls on it.
|
| Thanks for any help.
|
|
 
M

Mike Koewler

Rob said:
I'm not sure. But, I'm curious as to why you would need active hypertext in a document that's intended for print?

Sort of like a question about why animated gifs look great on screen but
won't work in a newspaper. :)

Mike
 
R

Rob Giordano \(Crash Gordon®\)

Back in the 60's animated gifs did work in newpapers...wow far out man...woooo did you see that pickture move :)))


| Rob Giordano (Crash Gordon®) wrote:
| > I'm not sure. But, I'm curious as to why you would need active hypertext in a document that's intended for print?
|
| Sort of like a question about why animated gifs look great on screen but
| won't work in a newspaper. :)
|
| Mike
| >
| >
| > | Hi.
| > |
| > | I used an Excel spreadsheet with active urls to create a merge file in
| > | Publisher. The urls converted to text with the merge. Does anyone know how
| > | to batch convert the text back to an active hyperlink, or if there is a
| > | macro somewhere? The spreadsheet has hundreds of urls on it.
| > |
| > | Thanks for any help.
| > |
| > |
 
M

Mike Koewler

Rob,

There was this character who used to hang out in prepress NG. He did
"Click Books." What I found fascinating about his method - he would pick
out a site where a high-rise office building was being built. Each
day, he would station his camera at the exact same place and take
pictures of the construction progress. When the building was completed
he had the pictures mounted on cardboard then bound. By flipping through
the book, one could see the building rising from the ground.

He said the hard part was learning how far away he needed to station his
camera and what angle to shoot the pictures from so the pictures moved
fluidly when flipping through.

Mike
 
M

Me

Thanks for responding. The answer to your question is that it will also be
available as a digital copy.
message I'm not sure. But, I'm curious as to why you would need active hypertext in
a document that's intended for print?


| Hi.
|
| I used an Excel spreadsheet with active urls to create a merge file in
| Publisher. The urls converted to text with the merge. Does anyone know
how
| to batch convert the text back to an active hyperlink, or if there is a
| macro somewhere? The spreadsheet has hundreds of urls on it.
|
| Thanks for any help.
|
|
 
R

Rob Giordano \(Crash Gordon®\)

ok, part 2, how will you go from Publisher to digital copy?...a pdf?


| Thanks for responding. The answer to your question is that it will also be
| available as a digital copy.
| message | I'm not sure. But, I'm curious as to why you would need active hypertext in
| a document that's intended for print?
|
|
| | | Hi.
| |
| | I used an Excel spreadsheet with active urls to create a merge file in
| | Publisher. The urls converted to text with the merge. Does anyone know
| how
| | to batch convert the text back to an active hyperlink, or if there is a
| | macro somewhere? The spreadsheet has hundreds of urls on it.
| |
| | Thanks for any help.
| |
| |
|
|
 
M

Me

Thank you again.
I had not made it that far. The hyperlinks had me stumped. But yes, pdf is
an option. If you say I will lose the links in that format also, I will not
be a happy camper!


message ok, part 2, how will you go from Publisher to digital copy?...a pdf?


| Thanks for responding. The answer to your question is that it will also
be
| available as a digital copy.
| message | I'm not sure. But, I'm curious as to why you would need active hypertext
in
| a document that's intended for print?
|
|
| | | Hi.
| |
| | I used an Excel spreadsheet with active urls to create a merge file in
| | Publisher. The urls converted to text with the merge. Does anyone know
| how
| | to batch convert the text back to an active hyperlink, or if there is a
| | macro somewhere? The spreadsheet has hundreds of urls on it.
| |
| | Thanks for any help.
| |
| |
|
|
 
R

Rob Giordano \(Crash Gordon®\)

No you shouldn't with a pdf. I was just thinking since Pub files can only be opened by Publisher...how would you create a digital version...I thought pdf would be logical.


| Thank you again.
| I had not made it that far. The hyperlinks had me stumped. But yes, pdf is
| an option. If you say I will lose the links in that format also, I will not
| be a happy camper!
|
|
| message | ok, part 2, how will you go from Publisher to digital copy?...a pdf?
|
|
| | | Thanks for responding. The answer to your question is that it will also
| be
| | available as a digital copy.
| | message | | I'm not sure. But, I'm curious as to why you would need active hypertext
| in
| | a document that's intended for print?
| |
| |
| | | | | Hi.
| | |
| | | I used an Excel spreadsheet with active urls to create a merge file in
| | | Publisher. The urls converted to text with the merge. Does anyone know
| | how
| | | to batch convert the text back to an active hyperlink, or if there is a
| | | macro somewhere? The spreadsheet has hundreds of urls on it.
| | |
| | | Thanks for any help.
| | |
| | |
| |
| |
|
|
 
M

Me

I do know there is a Publisher Viewer available for download and was just
going to go with that. I am guessing most people already have the Adobe
Reader so pdf would make more sense. IF the links are not lost!!

Thanks for the useful input.

message No you shouldn't with a pdf. I was just thinking since Pub files can only be
opened by Publisher...how would you create a digital version...I thought pdf
would be logical.


| Thank you again.
| I had not made it that far. The hyperlinks had me stumped. But yes, pdf
is
| an option. If you say I will lose the links in that format also, I will
not
| be a happy camper!
|
|
| message | ok, part 2, how will you go from Publisher to digital copy?...a pdf?
|
|
| | | Thanks for responding. The answer to your question is that it will also
| be
| | available as a digital copy.
in
| | message | | I'm not sure. But, I'm curious as to why you would need active hypertext
| in
| | a document that's intended for print?
| |
| |
| | | | | Hi.
| | |
| | | I used an Excel spreadsheet with active urls to create a merge file in
| | | Publisher. The urls converted to text with the merge. Does anyone
know
| | how
| | | to batch convert the text back to an active hyperlink, or if there is
a
| | | macro somewhere? The spreadsheet has hundreds of urls on it.
| | |
| | | Thanks for any help.
| | |
| | |
| |
| |
|
|
 
M

Mike Koewler

<< I do know there is a Publisher Viewer available for download >>

Can or will you share the URL with the legions of people who have been
told there is no such thing?

Mike
 
R

Rob Giordano \(Crash Gordon®\)

You found a viewer for pub files? Lots of people have been looking for one!...lots.

You can put links in pdfs...if you have lots of links you may have to re-figure how to get them in there...maybe excel table...dunno haven't tried.



| I do know there is a Publisher Viewer available for download and was just
| going to go with that. I am guessing most people already have the Adobe
| Reader so pdf would make more sense. IF the links are not lost!!
|
| Thanks for the useful input.
|
| message | No you shouldn't with a pdf. I was just thinking since Pub files can only be
| opened by Publisher...how would you create a digital version...I thought pdf
| would be logical.
|
|
| | | Thank you again.
| | I had not made it that far. The hyperlinks had me stumped. But yes, pdf
| is
| | an option. If you say I will lose the links in that format also, I will
| not
| | be a happy camper!
| |
| |
| | message | | ok, part 2, how will you go from Publisher to digital copy?...a pdf?
| |
| |
| | | | | Thanks for responding. The answer to your question is that it will also
| | be
| | | available as a digital copy.
| in
| | | message | | | I'm not sure. But, I'm curious as to why you would need active hypertext
| | in
| | | a document that's intended for print?
| | |
| | |
| | | | | | | Hi.
| | | |
| | | | I used an Excel spreadsheet with active urls to create a merge file in
| | | | Publisher. The urls converted to text with the merge. Does anyone
| know
| | | how
| | | | to batch convert the text back to an active hyperlink, or if there is
| a
| | | | macro somewhere? The spreadsheet has hundreds of urls on it.
| | | |
| | | | Thanks for any help.
| | | |
| | | |
| | |
| | |
| |
| |
|
|
 
M

Me

Oops! I went to this link http://beqiraj.com/office/viewer/index.asp
and it sure looked like one was available. Sorry.

JoAnn Paules said:
THERE IS??? I think you could sell subscriptions to that link.

--

JoAnn Paules
MVP Microsoft [Publisher]



Me said:
I do know there is a Publisher Viewer available for download and was just
going to go with that. I am guessing most people already have the Adobe
Reader so pdf would make more sense. IF the links are not lost!!

Thanks for the useful input.

message No you shouldn't with a pdf. I was just thinking since Pub files can only
be opened by Publisher...how would you create a digital version...I
thought pdf would be logical.


| Thank you again.
| I had not made it that far. The hyperlinks had me stumped. But yes,
pdf is
| an option. If you say I will lose the links in that format also, I
will not
| be a happy camper!
|
|
in
| message | ok, part 2, how will you go from Publisher to digital copy?...a pdf?
|
|
| | | Thanks for responding. The answer to your question is that it will
also
| be
| | available as a digital copy.
| | "Rob Giordano (Crash Gordon®)" <[email protected]>
wrote in
| | message | | I'm not sure. But, I'm curious as to why you would need active
hypertext
| in
| | a document that's intended for print?
| |
| |
| | | | | Hi.
| | |
| | | I used an Excel spreadsheet with active urls to create a merge file
in
| | | Publisher. The urls converted to text with the merge. Does anyone
know
| | how
| | | to batch convert the text back to an active hyperlink, or if there
is a
| | | macro somewhere? The spreadsheet has hundreds of urls on it.
| | |
| | | Thanks for any help.
| | |
| | |
| |
| |
|
|
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top