reading from excel into a webpage

[karambos]

I've been asked to create a webpage that reads certain cells from an
excel spreadsheet.

Is this possible?

--
karambos
------------------------------------------------------------------------
karambos's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=16262
View this thread: http://www.excelforum.com/showthread.php?threadid=392892

[aaron...@gmail.com]

yes it is quite easy to do this via clientside vbs

Public Sub CaptureExcelValues()

Dim xlApp
Dim wb
Dim ws
set xlApp = createobject("EXCEL.APPLICATION")
set wb = xlApp.workbooks.open("c:\myspreadsheet.xls")
set ws = wb.sheets("MyHappySheetName")

then you can just do anything that you want with it.

End Sub

[karambos]

Hi Aaron,

many thanks for the reply.

SO am I right in thinking that once I've created this app, I can just
link to it in my HTML page?

Cheers
K

[aaron...@gmail.com]

this app lives in IE. clientside vbscript works like a charm in IE

[karambos]

thanks for the reply, Aaron.

I'm a novice at this so please excuse the low level questioning.

I cut and pasted your code into Notepad. I saved it under the name
test.xls and created an HTML page to call this .xls file. It didn't
work

I suspect I don't understand just what the phrase "clientside vb"
means. I'd be grateful if you could clarify.

Many thanks