View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
Biff
 
Posts: n/a
Default Make a word formula

You're welcome!

Biff

"Chopper" wrote in message
...
That got it to work, thanks.

"Biff" wrote:

Try this:

="<a href="&""""&E8&""""&"_blank"&""""&"<img src="&""""&F8&""""&"
alt="&""""&A8&""""&" border="&""""&"0"&""""&"</a"

Returns:

<a href="URL"_blank"<img src="IMGURL" alt="BOARDNAME" border="0"</a

You sure you have the correct number of quotes? Seems to me that the one
after blank doesn't pair-up?

Biff

"Chopper" wrote in message
...
I am attempting to make a database for advertiseing web forums. I want
the
user to download the file, edit it and email it back to me. How here is
the
part I have a question about. I want te people to put in the board URL
and
their Mini Banner url and then excel make the code. The following is
what
I
am trying. ( l ) means start of new cell.

<a href=" l URL l "_blank"<img src=" l IMGURL l " alt=" l BOARDNAME l
"
border="0"</a

That would make "<a href="URL"_blank"<img src="IMGURL" alt="BOARDNAME"
border="0"</a

Basicaly anything in CAPS is what the user inputs. What should I do,
and
is
there a better way to do it.