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?

 

[aaron.kempf]

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 jus
link to it in my HTML page?

Cheers

 

[aaron.kempf]

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