reading from excel into a webpage

K

karambos

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

Is this possible?
 
A

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
 
K

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
 
K

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
 
Top