I have created an invoicing system that consists of a Word mail merge heading (invoicee name and account merged from an access database) and embedded Excel calendar style invoice (20 worksheets per workbook, 1 workbook per account) that computes daily charges. I store these 70+ individual account workbooks on a 2G mass storage device (H. I need to create a summary of annual charges for specific data on each monthly sheet for all client accounts: Data to be collected is located in 1 cell (H3) and a range of cells (SUM(B5:B35)) on each monthly worksheet.
I am unable to retrieve data from the 1 cell (H3) or sum of 31 cells (SUM(B5:B35)) of the word embedded Excel worksheets into an Excel summary sheet located in the same folder on H:. I have been able to link H3 cell data into the Excel summary worksheet using
=Excel.Sheet.8|'H:\PD2\Watson2-1.doc'!'!_1166956333!Jul04!R3C8'
but do not understand how to write formulas that will enable me to autofill rather that go cell by cell to create each link (What does !_1166956333 in '!_1166956333!Jul04!R3C8' stand for? How do I write a sum from the other word embedded worksheets into the Excel summary sheet?
dhughes
I am unable to retrieve data from the 1 cell (H3) or sum of 31 cells (SUM(B5:B35)) of the word embedded Excel worksheets into an Excel summary sheet located in the same folder on H:. I have been able to link H3 cell data into the Excel summary worksheet using
=Excel.Sheet.8|'H:\PD2\Watson2-1.doc'!'!_1166956333!Jul04!R3C8'
but do not understand how to write formulas that will enable me to autofill rather that go cell by cell to create each link (What does !_1166956333 in '!_1166956333!Jul04!R3C8' stand for? How do I write a sum from the other word embedded worksheets into the Excel summary sheet?
dhughes
