reading from excel into a webpage

  • Thread starter Thread starter karambos
  • Start date Start date
K

karambos

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

Is this possible?
 
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
 
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
 
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
 
Back
Top