HTML commands recognized in Excel?

[jlindahl]

I generate an excel spreadsheet from an asp page with the Response.ContentType &quot;application/vnd.ms-excel&quot; command. One of the fields in the table is a hyperlink, response.write &quot;<td><a href=dataentry_display.asp?&quot; & tRecSet.fields(x) & &quot; target='_blank'>&quot; & tRecSet.fields(x) & &quot;</a></td>&quot;
I want to be able to open this hyperlink in a new window. Currently I can only get it to open in the current window, and I need it to open in a new window.
Does Excel not recognize the target property?
Please help. Thanks.

 

[spazman]

target=&quot;_blank&quot; in the anchor tag.

 

[Veep]

Should work with a couple of single quotes added (see below in red) but...It looks like you're trying to create a querystring with no key. The value is there but no key:


&quot;<td><a href='dataentry_display.asp?MissingKey='&quot; & tRecSet.fields(x) & &quot;' target='_blank'>&quot; & tRecSet.fields(x) & &quot;</a></td>&quot;

 

[jlindahl]

i do have it in the anchor tag. it's being written through vbscript (response.write), so i only use a single quote, must i use a double quote?

 

[jlindahl]

Veep, those extra single quotes will not even allow the page to be found now.

 

[Veep]

Sorry. Lose the quote after the &quot;=&quot; sign.

&quot;<td><a href='dataentry_display.asp?MissingKey=&quot; & tRecSet.fields(x) & &quot;' target='_blank'>&quot; & tRecSet.fields(x) & &quot;</a></td>&quot;

Opens a new window on my box.

 

[jlindahl]

it still is not working. this is the link that it tries to open, which gives me a page cannot be found error, which is still in the same window.

http://localhost/gistracker_tba/arkansas/'DATAENTRY_DISPLAY.ASP?KEY=35527176'

when i leave out those new single quotes, i get the page i want, just not in a new window.