hyperlink variable

  • Thread starter Thread starter Looch
  • Start date Start date
L

Looch

Something simple here (hopefully)...how can I append the text in a
text box to a hyperlink? For example, I enter the string 'Printer223'.
There is an Excel file with the same name that I want to open
(Printer223.xls). Basically http://localhost/printers/whatever I put
in the textbox.xls is what I'm after. Thanks.
 
Something simple here (hopefully)...how can I append the text in a
text box to a hyperlink? For example, I enter the string 'Printer223'.
There is an Excel file with the same name that I want to open
(Printer223.xls). Basicallyhttp://localhost/printers/whateverI put
in the textbox.xls is what I'm after. Thanks.
Click to expand...

How do you want to open the file? Using a postback button?

Response.Redirect("http://localhost/printers/" + TextBox1.Text +
".xls");
 
How do you want to open the file? Using a postback button?

Response.Redirect("http://localhost/printers/" + TextBox1.Text +
".xls");
Click to expand...

Basically I just need to do this (using VBScript). The example below
doesn't seem to work though.

"http://amslpsvr1/consumables/OrderForms/" & strOrder &".xls"

Here's the actual code (I'm a noob but I can get any Excel file to
open this way!)

<script language ='vbscript' >
dim objExcel
dim wb
dim strOrder as string = me.txtOrderFrm.text
Sub cmdOrderFrm_onclick()
call OpenWorkbook("http://amslpsvr1/consumables/OrderForms/" &
strOrder & ".xls")
end sub
sub OpenWorkbook(strLocation)
set objExcel = CreateObject("Excel.Application")
objExcel.Visible = true
objExcel.Workbooks.Open (strLocation)
objExcel.UserControl = true
end sub
</script>

Thanks again for any help.
 
Looch said:
Basically I just need to do this (using VBScript). The example below
doesn't seem to work though.

"http://amslpsvr1/consumables/OrderForms/" & strOrder &".xls"

Here's the actual code (I'm a noob but I can get any Excel file to
open this way!)

<script language ='vbscript' >
dim objExcel
dim wb
dim strOrder as string = me.txtOrderFrm.text
Sub cmdOrderFrm_onclick()
call OpenWorkbook("http://amslpsvr1/consumables/OrderForms/" &
strOrder & ".xls")
end sub
sub OpenWorkbook(strLocation)
set objExcel = CreateObject("Excel.Application")
objExcel.Visible = true
objExcel.Workbooks.Open (strLocation)
objExcel.UserControl = true
end sub
</script>

Thanks again for any help.
Click to expand...

First of all, you are in the wrong newsgroup. This has nothing to do
with ASP.NET.

Anyway, depending on where you put the script, you are either getting
the value from the text box when the page is loading, or trying to get
it before the text box even exists.

If you want to get the value from the text box at the time of calling
the cmdOrderForm_onclick subroutine, you have to put the code that gets
the value inside the subroutine.

Note also that "me" gets a different meaning if you put it inside the
subroutine, as it then will refer to the control that you clicked rather
than the window object.
 
Back
Top