Depends what you mean by that. You can use an .xls as a datasource similiarly to how you would use a database. However, I would not really advise doing this because excel is not meant to have multiple users.
i just want users to be able to view the excel sheet, but i need to put other things on the page with the excel sheet. i'm getting the path of the file from a database. I tried doing a server side include, but i can't figure out how to make that dynamic.
You can do something such as:<BR><BR><%<BR>set objConn = Server.CreateObject("ADODB.Connection")<BR>objConn .Open "spreadsheet" ' Where this is a DSN <BR><BR>Set objRS = Server.CreateObject("ADODB.Recordset")<BR>objRS.Ac tiveConnection = objConn<BR>objRS.Source = "Select * from myRange1" 'This is a range<BR>objRS.Open<BR>%><BR><BR>Then you can access the information like this:<BR><BR><%<BR>DO WHILE NOT objRS.EOF<BR>FOR x = 0 to objRS.Fields.Count - 1<BR>Response.Write objRS.Fields.Item(x).Value<BR><BR>objRS.MoveNext<B R>LOOP<BR>%><BR><BR>Couple of thigns to keep in mind:<BR>1. The first row will be treated as field names<BR>2. The data in the columns MUST be teh same type (Can't have a word and then a number in the row after it)<BR>3. If you have multiple users looking at this at the same time your going to have a problem.