How can I display a value from a spreadsheet cell in a column in a document library?

I want to store expence sheets in a document library and be able to view the
total on each spreadsheet document in a column in the document library.
Does anyone know how to do this?

Regards
Roger Eriksen

The suggestions in the following Sharepoint newsgroup thread may help you:


http://groups.google.com/groups?&thr...TNGP15.phx.gbl

Roger Eriksen wrote:
> I want to store expence sheets in a document library and be able to view the
> total on each spreadsheet document in a column in the document library.
> Does anyone know how to do this?
>
> Regards
> Roger Eriksen
>
>
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

All the Expense Sheets must be the same, or have the cells of interest
RangeNamed ..........then you can have an Executive Abstract Workbook (EAB)
that contains a macro that can be run on demand that will go the Directory
where the expense sheets are filed, open each in turn, and extract the
cell/Range information you want and return it to the EAB, then close the
file.........this would give you an up-to-the-moment reading of what each of
those files contain. The macro will have to be very specific as to your
complete path, filenames, and cell locations, so you can't be having
directory names changing, etc. You could start out by trying to record it
and doing the first couple of files by hand, and then modify it later for
the rest.

Vaya con Dios,
Chuck, CABGx3




"Roger Eriksen" <Roger.Eriksen@itet.no> wrote in message
news:ujeK9Q9VFHA.1044@TK2MSFTNGP10.phx.gbl...
>
> I want to store expence sheets in a document library and be able to view
the
> total on each spreadsheet document in a column in the document library.
> Does anyone know how to do this?
>
> Regards
> Roger Eriksen
>
>
>