Starting Excel

[Neily]

I have a web site that I require to start excel read cell values and then close excel again. Can someone help me to do this. Thanks

 

[timferris]

Hi

You have to decide whether you want this to run server side or on the client side.

What are you looking to get out of excel?

Tim

 

[phattman]

There are two ways of doing this depending on how your spreadsheet is setup. You can either connect to it like a database and pull records (rows), or you can create an instance of the Excel app and just pull the values directly.

I'll show you how to do it the second way.

Dim objExcel, filename, path, outputvar1, outputvar2
path = "c:\temp\"
filename = "test.xls"
Set objExcel = CreateObject("Excel.Application&quot
objExcel.Workbooks.Open path & filename
objExcel.WorkBooks(filename).Activate
With objExcel.ActiveWorkbook.Worksheets("Sheet1&quot
outputvar1 = .Range("A1&quot.Value
outputvar2 = .Range("B5&quot.Value
End With
objExcel.Quit 2
MsgBox outputvar1 - outputvar2

For future reference, you can goto the Help file in Excel, then choose the Programming Information section to get a listing of all objects/methods/properties etc.