ASP - using a variable to specify excel which file to view

Forums

My Profile

Inbox

Address Book

My Subscription

My Forums

ASP - using a variable to specify excel which file to view

Logged in as: Guest

arrSession:exec spGetSession 2,3,32785

	Active Users: There are 0 members and 0 guests.
	Users viewing this topic: none

Printable Version

All Forums >> [Scripting] >> ASP >> ASP - using a variable to specify excel which file to view
Do you like VisualBasicScript.com? Link to us and help spread the word about our forum. Thanks!

Page: [1]

Message

<< Older Topic Newer Topic >>

ASP - using a variable to specify excel which file to view - 3/28/2006 8:22:43 AM

dave99

Posts: 0
Score: 0
Joined: 3/28/2006
Status: offline

Original message moved by Admin
Reason : Moved to a more appropriate category:)
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!