web interface for excel

[Guest]

hi all,

is there a way to have a web page (html or php) read portions of an excel
file?

if anyone has an example on how to read a cell from an .xls file into a text
field for web display, or a range of cells into a dropdown box - i'd greatly
appreciate it!

and secondly - is it possible to do the reverse - write to the file - or
call the macros in the file?

tia!

J

 

[Tim Williams]

You can "push" data from Excel into IE using automation, but unless
you're running very low security settings you will not be able to
automate Excel from within IE.

What exactly do you want to do?

Tim

 

[Guest]

Hi Tim!

i have an excel book that has all kinds of information - customer info,
order history, inventory levels, etc etc

i would like to be able to give our export manager (in another country)
certain information when she needs it - i have a summary page already created
in this workbook that would be sufficient - i also have a copy of this sheet
that works independently of the workbook - but needs to have access to it.

i thought if i could use a web interface to give access to read/interact
this would solve the problems

i can e-mail the 2nd book, but it will #VALUE out when it cannot find the
master book

suggestions?