Posted to microsoft.public.excel.programming

external usenet poster

Posts: 35

http link

I am having trouble in excel vs2002 with an if statement that I am trying to
build a hyperlink in.
If D4 if blank I want it to remain blank but if it is not I want to build a
http link.
It comes back but just as text. Doing a find replace after for the = sign
makes it a formula and works. Would like to do it without the find replace.
thanks..

=IF($D4="","","='"&$A$1&"["&F$3&TEXT($D4,"m-d-yy")&".xls]Daily
Schedule'!$AT$54")

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Pasting HTTP 'without' it being a clickable link??	Robert Blass	Excel Worksheet Functions	2	September 26th 08 10:52 AM
ADODB over HTTP?	LDB	Excel Programming	3	June 18th 07 09:15 AM
start http://..... vs hyperlink http://.....	ton de w	Excel Discussion (Misc queries)	0	May 4th 07 01:42 PM
HTTP link in Excel	Subs	Excel Programming	1	April 2nd 06 09:07 PM

All times are GMT +1. The time now is 07:12 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us