I am trying to view an Excel page in ASP, but I want to use a variable to determine which file I want to pull. How can I get the below excel file, FILE, to be based on an input variable from the web page?

Set cnnExcel = Server.CreateObject("ADODB.Connection")
cnnExcel.Open "DBQ=" & Server.MapPath("FILE.xls") & ";" & _
    "DRIVER={Microsoft Excel Driver (*.xls)};"

Thanks

Try this

Dim strXLSFile
strXLSFile = "[path]"

Server.MapPath(strXLSFile)

Hope that helps.

"The one language all programmers understand is profanity."

I assume what you are saying is brcd is a prefix for each excel file? if that is the case do something like tihs

dim strXLSFile
dim strFileSuffix

strXLSFile = "brcd"
strFileSuffix = Request.Form[QueryString]("fileSuffix")
strXLSFile = strXLSFile & strFileSuffix

Set cnnExcel = Server.CreateObject("ADODB.Connection")
cnnExcel.Open "DBQ=\\JOHN\DDX Capital\Investment Summaries\" & srXLSFile & ";" & _
    "DRIVER={Microsoft Excel Driver (*.xls)};"

Hope that helps.

"The one language all programmers understand is profanity."

Simple enough.

Dim strXLSFile
strXLSFile = Request.Form([form field name])

That will do it.

"The one language all programmers understand is profanity."