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

  • Thread starter Thread starter Roger Eriksen
  • Start date Start date
R

Roger Eriksen

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
 
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
 
Back
Top